Dax - Max date by Month

[Anonymous]

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 of MAX. Right now I'm working with a custom field that is adding a flag for the max Forecast Date:

MaxForecastDate = if(max('Monthly Forecast'[ForecastDate])='Revenue Monthly Forecast'[ForecastDate],1,0)

However, I think I need this to be a measure so it'll be dynamic based on the month I have displayed (Report filters by month, so it's fine for this month (Sept) because the MaxForecastDate =1 where ForecastDate=9/2/20, but if I switch to last month it just shows blank - no MaxForecastDate=1 for any of the August forecast records). 

[amitchandak]

@Anonymous , Can you share sample data and sample output in table format?

[Anonymous]

@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.

[V-pazhen-msft · Accepted solution]

@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.

[Pragati11]

Hi @Anonymous ,

Can you share additional details like sample data, screenshots, etc.?

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Thanks,

Pragati