Forum Discussion
kormosb
Helper III
Helper IIIDAX - t-1 value - Missing values
Hi, I am facing an issue I would like to get help with. I woud like to calculate the value of the previous quarter with the following DAX: Value T-1 = CALCULATE('Value'[Value T],DATEADD('Q...
Hi kormosb ,
Would you please try to use the following measure :
Value T-1 = CALCULATE('Value'[Value T],FILTER(ALL('Quarter'),'Quarter'[Last day of Quarter] = EOMONTH(MAX('Quarter'[Last day of Quarter]),-3)))If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
v-deddai1-msft
Community Support
Community SupportHi kormosb ,
Would you please try to use the following measure :
Value T-1 = CALCULATE('Value'[Value T],FILTER(ALL('Quarter'),'Quarter'[Last day of Quarter] = EOMONTH(MAX('Quarter'[Last day of Quarter]),-3)))
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai