Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
So I was using Max (date) successfully to get the cummulative revenue in 2021 with a filter like date< max(date) on a measure. The max(date) with the filter context returns the correspondent month in the chart.
I tried the same thing with the lastdate, but it seems it ignores the filter context giving me in every month the revenue of the Lastdate(which is september).
I thought these functions would be similar.
Any ideas on why there is a difference?
Solved! Go to Solution.
@campelliann If you have it working, I'd walk away and declare victory. What does the LASTDATE version of that look like? This?
calculate(sum(Valores_Finais[Total]),filter(all('Z_Calendário Slicer'),'Z_Calendar Slicer'[YearMonth]<=LASTDATE('Z_Calendar Slicer'[YearMonth])),filter(all(Valores_Finais),Valores_Finais[Type]="Baseline"))
I don't see how that would work since you would be trying to compare a scalar to a table. And if it is this:
calculate(sum(Valores_Finais[Total]),filter(all('Z_Calendário Slicer'),LASTDATE('Z_Calendar Slicer'[YearMonth])),filter(all(Valores_Finais),Valores_Finais[Type]="Baseline"))
Then you would only get the last (biggest) [YearMonth] and would lose the < part.
First and foremost thank you for your help.
@Greg_Deckler @Anonymous the measure I am using is this:
@campelliann If you have it working, I'd walk away and declare victory. What does the LASTDATE version of that look like? This?
calculate(sum(Valores_Finais[Total]),filter(all('Z_Calendário Slicer'),'Z_Calendar Slicer'[YearMonth]<=LASTDATE('Z_Calendar Slicer'[YearMonth])),filter(all(Valores_Finais),Valores_Finais[Type]="Baseline"))
I don't see how that would work since you would be trying to compare a scalar to a table. And if it is this:
calculate(sum(Valores_Finais[Total]),filter(all('Z_Calendário Slicer'),LASTDATE('Z_Calendar Slicer'[YearMonth])),filter(all(Valores_Finais),Valores_Finais[Type]="Baseline"))
Then you would only get the last (biggest) [YearMonth] and would lose the < part.
It is explained in detail here :
Difference between LASTDATE and MAX for semi-additive measures in #DAX - SQLBI
Thanks
Raj
@campelliann @Anonymous The only correction I would make to that article is that you can use MAX in a table context versus scalar by simply doing:
{ MAX('Dates'[Date]) }
In that respect, it is identical then to what LASTDATE returns. In other words, LASTDATE is a utterly useless function.
User | Count |
---|---|
125 | |
108 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |