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 ,

 

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

 

Thank you.