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 ,

 

I wanted to follow up on our previous suggestions. We would like to hear back from you to ensure we can assist you further.

 

Thank you.