TOTALYTD works, TOTALMTD does not - same data

Hello. I'm having issues using the TOTALMTD function. When I use the exact same data with the TOTALYTD function my data works normally. I have 2 tables. Table 1 :INSPECTIONS Column 1 ...

Need Help

alanhodgson
9 years ago
Hey mc625569,

It is definitely behaving strange. I tested a few things and found that if I add a slicer to the page for "MonthNameLong" from the 'Date Table' and select "January", then the MTD populates correctly. Also, you can get the MTD to populate by changing the formulas for both MTD and YTD to go off the "Inspections[DateNoTime]" column instead of the Date column from the 'Date Table'. See below:

Hope this helps,

Alan

alanhodgson

Solution Supplier

9 years ago

Hey mc625569,

Can you provide some more information on your situation?

I tested the 2 formulas and they worked correctly on my data set (Excel file). Make sure there are no slicers/filters on the table you are working on. Also, make sure there formulas are used to make measures not columns. See below: