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
CNENFRNL's avatar
CNENFRNL
Icon for Community Champion rankCommunity Champion
4 years ago
= 
CALCULATE(
    SUM( 'Total-Count'[Count] ),
    DATESMTD( 'Total-Count'[Date] ),
    REMOVEFILTERS( 'Total-Count'[Date] )
)