topic Re: How to calculate next Month last snapshot in DAX Commands and Tips

How to calculate next Month last snapshot

mengjiehe — Thu, 20 Jul 2023 11:25:23 GMT

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]))))

Re: How to calculate next Month last snapshot

Legend_11 — Thu, 20 Jul 2023 17:11:47 GMT

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.

Re: How to calculate next Month last snapshot

mengjiehe — Fri, 21 Jul 2023 00:13:54 GMT

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.