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.
Hi
Does anyone know why this DAX doesnt work...
Example of my data table below:
Solved! Go to Solution.
So, the way that I would do this in a measure would be something along the lines of:
Prior Week =
VAR __PreviousWeek = MAX('FactNELWeekly'[Previous Week No.])
RETURN
CALCULATE([UAP's],FILTER('FactNELWeekly'[Week] = __PreviousWeek)
Solved:
Hi @Anonymous ,
Based on @Greg_Deckler 's suggestion,the measure needs to be corrected as below:
Prior Week =
VAR __PreviousWeek = MAX('FactNELWeekly'[Previous Week No.])
RETURN
CALCULATE([UAP's],FILTER('FactNELWeekly','FactNELWeekly'[Week] = __PreviousWeek)
WoW=[UPA's]-_PreviousWeek
Hi Kelly @v-kelly-msft
I have an additional question on this topic, everything works with the DAX above, so thanks againn for that. But im noticing there's a week 0 appearing, and actually I've replicated this for a monthly report and again, im getting a 0 month. Is there a way to take care of this scenario within the same Dax formula? I figured it would be linked to this formula, hence why im posting here.
I'm googling this now acutally, but thought i'd try my luck here at the same time :).
Thanks
Ben
thank you so much!
this did the trick nicely, really appreciated!
Thanks @v-kelly-msft ! That's what happens when I don't actually test my DAX, I mess up some syntax!
So, the way that I would do this in a measure would be something along the lines of:
Prior Week =
VAR __PreviousWeek = MAX('FactNELWeekly'[Previous Week No.])
RETURN
CALCULATE([UAP's],FILTER('FactNELWeekly'[Week] = __PreviousWeek)
Thank you so much, this worked!
Much appreciated.
HI,
It could be something like this (if it's a calculated column):
var previousWeek = FactNELWeekly[Previoud Week No.]
return
CALCULATE([UAP's],FactNELWeekly[Week No.] = previousWeek)
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |