Forum Discussion
CLOSINGBALANCEMONTH DAX Issue
Are you looking for a cumulative total every month, like
calculate ( SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= max('Date'[date])),[Category] = "Furniture" ) calculate ( SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= date(2020,08,31)),[Category] = "Furniture" )Make sure you have a calendar table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/
Are you looking for a cumulative total every month, like
calculate (
SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= max('Date'[date])),[Category] = "Furniture" )
calculate (
SUM ( Order2020[Profit] ),FILTER('Date','Date'[Date]<= date(2020,08,31)),[Category] = "Furniture" )Make sure you have a calendar table
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :
https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions
https://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/