Forum Discussion

adityavighne's avatar
adityavighne
Continued Contributor
7 years ago

Remove Card/KPI Error

Hi team,   I want to remove card/KPI error (cross) instead of that I want blank or zero  
Need Help
Tips and Tricks
TeigeGao's avatar
TeigeGao
Solution Sage
7 years ago

Hi adityavighne ,

Could you please share more information about your problem? Do you delete a measure? 

Best Regards,

Teige

  • adityavighne's avatar
    adityavighne
    Continued Contributor
    7 years ago

    No, I haven't deleted measure.

    This visual is MoM measure so whenever previous month data is not available so the calculation output I want 0 or blank instead of an error.

    • TeigeGao's avatar
      TeigeGao
      Solution Sage
      7 years ago

      Hi adityavighne ,

      Actually, the dateadd() function is a time intelligence function, it rrequires a continous time, you can try to use the IF() function to handle the not available data to zero, for example IF(dateadd(****) = blank() , 0, ***), besides, you will need to create a continous date table which cover the previous date.

      Best Regards,

      Teige

      • adityavighne's avatar
        adityavighne
        Continued Contributor
        7 years ago
        This is my measure - 
         
        1)
        [Total Goal Completions] = sum(column 1)+ sum(column 2)
        MoM % GC = ([Total Goal Completions])-[GC Prior Period]/[GC Prior Period]
         
        2)
        MoM % Clicks = (SUM('PROD PaidMedia'[Clicks])-[Clicks Prior Period])/[Clicks Prior Period]