Questions tagged [dax]
Expression language used in Microsoft Power Pivot, Analysis Services, and Power BI for performing analytical calculations.
9,510
questions
0
votes
0
answers
9
views
Selected Previous Amount in DAX
I have a rank table as below which is merged with my FactTable. Previous_Amount works find until I select 2 non consecutive FYandFWOnum number.
FYandFWOnum Rank
202448 1
202452 ...
0
votes
0
answers
13
views
Accessing the previous rows of the same calculating column in dax
I am creating a new calculated column called Final_Value in my calculated table called INDEX_1.
The condition is I have three columns called Kombi,JJJJ_MM, Value. Each kombi consists one row entry for ...
1
vote
0
answers
13
views
POWER BI What is causing the circular dependency?
I am trying to create a new table called 'daily_rainfall' in Power BI with 5 columns: city, total_rainfall_3months_ago, total_rainfall_2months_ago, total_rainfall_last_month, total_rainfall_this_month....
0
votes
0
answers
14
views
Power BI - Using Summarize and Maxx, then remove filter
I'm working on a visual which is a number of guages, each related to a particular location within the organisation. I'm trying to create a measure which will give me the same max value across all ...
2
votes
1
answer
25
views
Need help in filtering using measure in power bi
I have 2 measures in my power bi report which show cumulative trend based on two date columns namely created date and closed date. The 2 trend lines show total number of bugs created vs total number ...
0
votes
0
answers
19
views
Build a visual with KPIs from different tables
There is a report that is currently in Excel but I'd like to move it to Power BI:
2023 Actual = Actual sales 2023
2024 Actuals = Actual sales 2024
2024 Target = Sales Targets 2024
Variance to Target =...
0
votes
0
answers
17
views
Power BI Retail Sales LY Same Day of Week Same Week Number
I have an interesting dilemma. In Power BI I would like to make comparisons to the same day of week same week number last year. In Power BI I have not found a way to create this. There is the function ...
1
vote
0
answers
29
views
How to Sum by field on different table
I'm trying to create a measure that will Sum the forecasted and actual proceeds a client receives for all of the companies they own. Data model is structured in a star schema with Clients as the fact ...
0
votes
1
answer
18
views
Filter slicer using a measure
In my report I use two tables "NomData" and "ReadData_Perm".
I have a measure to identifie my needed EventTypeCodes by UserLogin:
FilterEventByUser =
IF(
MAX(...
0
votes
3
answers
30
views
I want DAX calculated column in Power BI with following requirements
I have table with column A having repeated reference and column B status with text value G1, G2, G3, G4 and G5 which might be assigned to distinct reference with multiple statuses like as below.
I ...
0
votes
0
answers
15
views
Power Bi Integration with Rest API using selected slicer values
I have a deployed ML model. I am using a Flask app to use the model and return predictions. It is a post request which input payload in this form
{
"input_features": [
feature_list1,
...
0
votes
0
answers
25
views
Creating a dynamic zscore in powerBI using count as aggregate
I am trying to create a couple measures that will dynamically adjust a z-score value based on a count of entries in the the table that match both the month/year and the exception code.
Effectively ...
1
vote
1
answer
35
views
Simplifying DAX Statement
In order to get data from the MSFT Teams Call Quality Data warehouse (OLAP). https://learn.microsoft.com/en-us/microsoftteams/dimensions-and-measures-available-in-call-quality-dashboard
There are a ...
0
votes
1
answer
30
views
Derive values from previous Quarters
I have a table called Hyp with below data
Quarter Target Date
Q1 50 Dec 31,2023
Q2 65 Mar 30,2024
Q3 90 June 30, 2024
Q4 120 Sep 30, 2024
Basically the targets are ...
0
votes
1
answer
18
views
Problem Filter with extract Button Power BI DAX
I have a problem with extraction Button in Power BI.
When I apply this Formula, my table on PBI give me a result for each company (X,Y,Z) whereas I just want the result for the company selected with ...