Forum Discussion

jsullivan928's avatar
jsullivan928
New Member
2 years ago
Solved

Direct Query user needing to add a calculated column

I am working in Direct Query where I don't have access to the actual data due to SQL permission rights and the application I am pulling the data from won't allow any changes to the database. When I d...
Need Help
  • PijushRoy's avatar
    PijushRoy
    2 years ago

    Hi jsullivan928 

    Please create calculated column with Switch statement in Power BI desktop, not in Power Query.

    Thanks
    Pijush

  • mussaenda's avatar
    mussaenda
    2 years ago

    Hi jsullivan928 ,

     

    Switch is a DAX expression. And currently you are in M query.

    If you want to continue working in M Query, use the If-else statement.

    If you want to continue using Switch, use the dax in a calculated column.

PijushRoy's avatar
PijushRoy
Community Champion
2 years ago

Hi jsullivan928 

Please create calculated column with Switch statement in Power BI desktop, not in Power Query.

Thanks
Pijush