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 ,

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]