My MTD Calculation is showing only NULL

Question

Hi I have a calculation for Month to date as , in the browser it is only showing as NULL, please help.

Thanks

MTD=

SUM   
   (  
      MTD([Charge Create Date.Display Date].[Date])  
     , [Measures].[Set 01 Charge Amount]  
     )

Answer 1

Hi @BK

Maybe you can refer to the content in these links.

[https://stackoverflow.com/questions/30127534/mtd-function-not-working-with-scope

[https://social.msdn.microsoft.com/Forums/sqlserver/en-US/caa49401-9ad9-4abc-b3cb-d6c6ed66331c/ssas-calculated-measure-ytd-using-named-set?forum=sqlanalysisservices

Best regards,

Percy Tang

---

If the answer is the right solution, please click "Accept Answer". If you have extra questions about this answer, please click "Comment".

Answer 2

Thanks I had the same issue and this solution works for me.

Thanks

Answer 3

Please check:

• Is the "Charge Create Date.Display Date" field a valid date field. If it is not, the MTD function will not be able to use it to calculate the month-to-date value.
• Is the "Set 01 Charge Amount" field a valid numerical field. If it is not, the SUM function will not be able to use it to calculate the total.
• Is the date field in the correct format, as the MTD function may be expecting a specific format.
• Is there any missing data, as this can cause the MTD function to return null.
• Is the "Charge Create Date.Display Date" field in the same hierarchy as the "Measures"."Set 01 Charge Amount" field, as the MTD function expects both fields to be in the same hierarchy.