Forum Discussion

Rahul_SC's avatar
Rahul_SC
Icon for Helper IV rankHelper IV
3 years ago
Solved

Replace blank in metrix

Hi, I want to replace blank values with "No value" in metrix table. I am using some if condition to filll it or used coalesce dax also. But not able to fill blank values with alternative values. Bel...
@Dax help
  • tamerj1's avatar
    tamerj1
    3 years ago

    Rahul_SC 

    Use a dim table for for week number. 

Rahul_SC's avatar
Rahul_SC
Icon for Helper IV rankHelper IV
3 years ago

Hi tamerj1 ,

 

I had tried this, and again tried it. It is still give empty value.

 

 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Rahul_SC 

Use a dim table for for week number. 

  • Rahul_SC's avatar
    Rahul_SC
    Icon for Helper IV rankHelper IV
    3 years ago

    Hi tamerj1 , thanks, now, it works.

     

    but it must work without dim table. Because I need to use any other catogorical column. 

     

    Let's say, If I have a column where names are there (ex - A, B, C, D ----etc.). then I want to make it work ? how we can do that ?