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
Super User
Super UserAnonymous , Can you share sample data and sample output in table format?
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.