Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How to replace empty cells to zero (0) in matrix column values using direct mode.

i am using direct query, 2 columns product service, product status and below is sample data product service, product status phase 1               open phase 2               started phase 3     ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    I had a look at your file and have updated the file as you require.

    Download the file here

     

    Appreciate your kudo!! Mark this post as solution if this works for you.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

 

Hi Nikhil,

 

Thanks for your time, please check the sample file below. I have tried with both measure and measure 2 but still i am not able to show 0 instead of blank vallues. 

 

https://1drv.ms/u/s!AlARJq6xd5KedVlP0zJpo2xgG_s?e=tR2Okt

 

Please share your ideas and solution. Thank you.

 

Thanks,

Mahi1827

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Anonymous ,

I had a look at your file and have updated the file as you require.

Download the file here

 

Appreciate your kudo!! Mark this post as solution if this works for you.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Nikhil,

     

    This logic is working as expected.Thank you so much for your time and help on this.

     

    Thanks,
    Mahi