Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Unable to replace blank values cells

Hi,   I am unable to replace the blank values with "NA". Here is the situation, there are some metric names that available in data source for the sept month but the values are empty,  and for the ...
General Comment
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a seperate table for metric_name and join back it with you table and use mertic_name from the new tbale, Then this formula should work

     

    New Table

    mertic = distinct(mertic_name )

    Also explore this option

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try like

Test =
var b = AVERAGE(archer_kri_latest_summary[derived_value]) +0
return IF(ISBLANK(b) || b=0 ,"na",b)

 

or

 

Test =
var b = AVERAGE(archer_kri_latest_summary[derived_value]) +0
return IF(ISBLANK(b) || b=0 ,"na",b&"")

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Amit,

     

    thanks for replying, i tried both but it did not work.