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

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.

Answer 3

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

Thanks