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 with the amounts in each row, please?

 

DateCategoryAmountBikeScooterSkate
01/04/2025Bike475475  
01/04/2025Bike600600  
01/04/2025Bike350350  
02/05/2025Scooter200 200 
02/05/2025Bike750750  
02/05/2025Skates150  150
02/05/2025Scooter80 80 
03/06/2025Skates200  200
03/06/2025Skates225  225
03/06/2025Skates300  300


Thanks

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() )

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    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.

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi RichOB ,

     

    I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

     

    Thank you.

  • 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.