Forum Discussion

RichOB's avatar
RichOB
Post Partisan
1 year ago
Solved

Adding a column

Hi, in my real-life example, I don't have the individual columns per category, but I need them. In the example below, how can I add the Bike, Scooter, and Skate columns based on the first 3 columns ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    1 year ago

    RichOB In Power Query, it would be something like:

    Bike = if [Category] = "Bike" then [Amount] else null

Scooter = if [Category] = "Scooter" then [Amount] else null

Skates = if [Category] = "Skates" then [Amount] else null

     

    In DAX it would be:

    Bike = IF( [Category] = "Bike", [Amount], BLANK() )

Scooter = IF( [Category] = "Scooter", [Amount], BLANK() )

Skates = IF( [Category] = "Skates", [Amount], BLANK() )
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RichOB ,

Thank you for reaching out to the Microsoft fabric community forum.

 

As rightly explained by Greg_Deckler , you can achieve this either in Power Query using conditional column logic or in DAX using calculated columns. Both methods will create the expected output where each category has its own column, and the corresponding amount appears only when applicable.

Please feel free to choose the method that best fits your transformation stage (Power Query vs. data model). Also Please reach out for further assistance.

 

Thank you.