Forum Discussion
Dax - Max date by Month
I have a table that is tracking weekly snapshots for Monthly Sales Forecast. Based on the month that is displayed, I want it to show the data for the last snapshot. I assume it needs to use some form...
Anonymous
You need to check the max forecast date for each period, try create this column.Column = IF([Forecast Date]=CALCULATE(MAX([Forecast Date]),ALLEXCEPT('Table','Table'[Period])),1,0)Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
amitchandak Pragati11 Here is what I have and what I'm looking for (not sure how to put data in a sample output table). For each period, I need the max Forecast Date.
Anonymous
You need to check the max forecast date for each period, try create this column.
Column = IF([Forecast Date]=CALCULATE(MAX([Forecast Date]),ALLEXCEPT('Table','Table'[Period])),1,0)
Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.