Forum Discussion

AJTK's avatar
AJTK
Frequent Visitor
2 years ago
Solved

TotalMTD Function Not Working As Intended

Hi, I'm stumped here.    I have a table with Production info. It's linked to my DimCalendar. My issue is the Yesterday's Production and YTD Production both show correct values, but the MTD Producti...
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi AJTK 


    Have you set your calenadar table as a Date table?

    What are you trying achieve by having the ALL('Production Table'[Production Date]) at the end of the measure? 

    TOTALYTD MTD need a date context to work. 

     

    Example. TOTALMTD([Measure_Total Poduction],'DimCalendar'[Date]) will show balnk if there is no date filter on the page or no date context in the visual. Lets say if you choose a date range between Nov 23 and March 24 in a date filter/slicer, you will get MTD for March 24, but if you have a visual with dates in it, you will get the MTD to end of each month visible in the visual.

     

    I hope this clears up what you need.

     

    Thanks

    Joe

     

    If you found my answer helpful and it solved your issue, please accept as solution

     

     

Joe_Barry's avatar
Joe_Barry
Solution Sage
2 years ago

Hi AJTK 


Have you set your calenadar table as a Date table?

What are you trying achieve by having the ALL('Production Table'[Production Date]) at the end of the measure? 

TOTALYTD MTD need a date context to work. 

 

Example. TOTALMTD([Measure_Total Poduction],'DimCalendar'[Date]) will show balnk if there is no date filter on the page or no date context in the visual. Lets say if you choose a date range between Nov 23 and March 24 in a date filter/slicer, you will get MTD for March 24, but if you have a visual with dates in it, you will get the MTD to end of each month visible in the visual.

 

I hope this clears up what you need.

 

Thanks

Joe

 

If you found my answer helpful and it solved your issue, please accept as solution