Forum Discussion
DAX LastNonBlankValue
Hi,
If we have 5 years of data for total month, quarter and year
May I know how to calculate last blank value
For each month
For each quarter
For each year
Using DAX.
Hi Sweetie ,
It's always better to show some input and desired result.
As for yor request, please refer to this article: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
2 Replies
Hi Sweetie ,
It's always better to show some input and desired result.
As for yor request, please refer to this article: https://www.sqlbi.com/articles/semi-additive-measures-in-dax/
If this post helps, then please consider Accept it as the solution ✔️to help the other members find it more quickly.
