Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I need to make a measure, the difference of the revenue with the largest year in the filter less the previous year and I have 6 different years.
I have this:
Max year(measure) = Calculate the largest year of the column
Max year-1(measure) = Calculate the previous year of the largest.
And this is the new measure that I am trying to do:
Var Years = (CALCULATE(SUM(BD[Revenue]),BD[Year Report]=[MAX YEAR])) - (CALCULATE(SUM(BD[Revenue]),BD[Year Report]=[MAX YEAR-1]))
Thanks!
Solved! Go to Solution.
You are using measures as filter criteria. I believe that has to be nested inside an explicit FILTER() statement.
Your Measure = CALCULATE([Whatever], [Measure] = "x")
Correct Measure = CALCULATE([Whatever], FILTER(TableName, [Measure] = "x"))
Proud to be a Super User!
Hi @Kemir,
I think you can take a look at below link which about the compare between two years:
Comparing this year and last year measure on a bar chart
Regards,
Xiaoxin sheng
Hi,
The calculate would be for the 5 different years.
You are using measures as filter criteria. I believe that has to be nested inside an explicit FILTER() statement.
Your Measure = CALCULATE([Whatever], [Measure] = "x")
Correct Measure = CALCULATE([Whatever], FILTER(TableName, [Measure] = "x"))
Proud to be a Super User!
It does not work yet.
This is my measure:
My Measure: = (CALCULATE(SUM(BD[Revenue]),BD[Year Report]=MAX(BD[Year Report])) - CALCULATE(SUM(BD[Revenue]),BD[Year Report]=(MAX(BD[Year Report])-1)) )
I need that the criteria would be the largest number in the column.
Thanks!
All right!!!
Well it won't work if you don't actually do what I said...
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |