Forum Discussion
DAX Previous Month and Filtering
Hi mosman
Could you create a column that gets the max date for each month in your date table? Then create a helper table that is linked to your date table, with only the distinct values of that column?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Nathaniel_C,
the users would like to see one date at the time like this:
the measure looks like this:
Starting Balance Amount = CALCULATE(SUM('FactSales'[currentBalance]),ALL(DimDate),PARALLELPERIOD(DimDate[Date],-1,MONTH))when I use the date from the time intelligence table in the slicer, it looks like this:
but I want it to look like this:
Hi mosman ,
Might you create a column in the Date table that gives you the max date for each month and use that for your slicer?
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel