Forum Discussion
Solved
DAX Previous Month and Filtering
Hello all, I have table with sales and dates, the table is an aggregate table, it calculate the total sales for the month end. it looks like this: Product_Category Sales Amount Date Bikes ...
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 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