Forum Discussion
Solved
TOTALMTD() now showing nulls or missing
I'm looking to include people who don't have hours for the prior month as blank or 0. Currently the measure looks like: MTD Hrs = TOTALMTD(sum(Table[Hours]),[Date]) Data Example if today is 1...
Looks like this issue is the result of a bigger issue due to not having a single date table. Thanks all for your assistance though!
v-ljerr-msft
Microsoft Employee
Microsoft EmployeeHi teresadanna,
In addition, you should also be able to simply add "+ 0" to your formula to get the expected result. :smileyhappy:
MTD Hrs = TOTALMTD ( SUM ( Table[Hours] ), [Date] ) + 0
Regards
Looks like this issue is the result of a bigger issue due to not having a single date table. Thanks all for your assistance though!