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
Solution 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

 

 

 

eerba2's avatar
eerba2
Frequent Visitor
8 years ago

i'm having the same issue. both my QTD and YTD work as expected but the MTD has many blanks in my table. I added January to the table visual filter and that fixed it but, is there a way to built this into the measure instead of using visual filters? What is causing the MTD measure to behave diferently than QTD and YTD?

 

i'm using dates from a Time.Date dimension in a cube with no gap in dates.