How to calculate next Month last snapshot

[mengjiehe]

I wrote a measure "Next Month End" to capture the value of last snapshot of next month for the selected snapshot but it didn't work.

For example, if I select 2/6/2023 or 2/19/2023, I want to see "Next Month End" measure can capture the value in snapshot 3/30/2023. But my DAX not work... actually nothing comes out. See last screenshot in the bottom.

Next Month End = CALCULATE(sum(Demand[Demand]),FILTER(ALL(Snapshot[Snapshot]),Snapshot[Snapshot]=endofmonth(NEXTMONTH(Demand[Snapshot]))))

[Legend_11]

Next month dax =
VAR EndDate1 = EOMONTH(FIRSTDATE('Table'[Snapshot]),+1)

return CALCULATE(sum('Table'[Demand]),'Table'[Snapshot]=EndDate1)

Could you try above measure? I passed the date as variable and taken the next month last date and use it in filter

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[mengjiehe]

Hi Thanks, looks it didn't work in the database. I guess becasue the EOMONTH is returning calendar last day of each month but in my Snapshot the last one may not the exact last day of that month.