Forum Discussion

mc625569's avatar
mc625569
Regular Visitor
9 years ago
Solved

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's avatar
    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's avatar
alanhodgson
Icon for Solution Supplier rankSolution Supplier
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

 

 

 

beachamtresa's avatar
beachamtresa
New Member
9 months ago

This post should not be marked as solved since its not solved in the comments.  same issues.