Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

SWITCH with no values

Hi everyone,    i would like to know how i can fix this formula please ?    If in the table Agglo Commerciale'[Nom Strate Commerciale], I find "Monoprix" or "Carrefour so "RETAIL", If is blank "C...
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Anonymous ,

    Thank you for reaching out to Microsoft Fabric Community.

    Thank you Greg_Deckler for the prompt response.

     

    I have created corrected DAX measure using sample data to replicate the requirement.Please go through the attached PBIX file for your reference.

    Thank you.

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi Anonymous ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Greg_Deckler for the prompt response.

 

I have created corrected DAX measure using sample data to replicate the requirement.Please go through the attached PBIX file for your reference.

Thank you.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi v-venuppu 

thank you for your response, it works ! But I think about it, do you think it's possible to create it with a new column in the dataset instead of calculation? 

 

Thank you,