Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Rename blank Direct Query

Hello,

 

I want to rename a filter who is "empty" to "Yes"

 

where there is "Vide" i want to have "Yes" is it possible to do that in DAX ? i'm in direct Query.

 

Thank you for the help

tips & tricks

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    5 years ago

    HI Anonymous ,

     

    In edit query window you can right click on column and select replace values

    Now pass blank "value to find" and write "Yes" in "replace with"

     

    Thanks,

    Samarth

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello Samarth_18 ,

       

      Thank you for your answer, but like i said i didnt import the data, im in direct query.