Forum Discussion

andrewb95's avatar
andrewb95
Icon for Helper II rankHelper II
4 years ago

MTD - Calculation not working

Please see the image above, I have attempted to calculate the count for the month to date as you can see. I would expect on the 15/09 as I am perfoming this calculation it should return 145 add...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago
MTD =
CALCULATE (
    SUM ('table'[Count]),
    FILTER (
        ALL ('table'),
            'table'[Date]<= MAX ('table'[Date]))
          )
 
this formula works for me and if you want to add the specific filter please add after ALL
 
MTD =
CALCULATE (
    SUM ('table'[Count]),
    FILTER (
        ALL ('table'),'table'[Defect Category - 1]="KK"&&
            'table'[Date]<= MAX ('table'[Date]))
          )