TOTALMTD empty days

[mrslyfox]

Hello,

Have a folowing formula

MTD Sales:=TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date])

Which gives me almost expected results.

Trouble only with last marked by red days. Result for those days should blank.

[TomMartens]

A quick solution would be to put your calculation into an if statement, that checks if your measure is not null like this

IF(NOT(ISBLANK(sum of your measure)), your calculation, BLANK())

You have to consider that this formula also surpresses the calculation for days where there is no data, for a business reason.

[mrslyfox]

Hello @TomMartens

Result of

MTD Sales:=IF(NOT(ISBLANK(TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date]))),TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date]),BLANK())

returned the same result as it was from the beginning.

[TomMartens · Accepted solution]

Hey

your formula should look like this

MTD Sales:=IF(
 NOT(
  ISBLANK(
   SUM(F_Delivery_Note[DELNL_TotalGrossSqm])))
   ,TOTALMTD(SUM(F_Delivery_Note[DELNL_TotalGrossSqm]),D_Date[LINK_Date])
   ,BLANK()
  )