Forum Discussion

motionid's avatar
motionid
New Member
4 years ago
Solved

Create column from another column if row does not contain...

Hi all, Very new to DAX and the Power BI world.   Was wondering if I would write the following where rows are extracted and placed into a new column if the column does NOT equal xxx content. i.e....
Need Help
  • mohammedadnant's avatar
    mohammedadnant
    4 years ago

    Hi motionid 

     

    You can use Conditional Column in Power Query (pls refer to this video: https://youtu.be/7UgqPhu1rN0)

    in Power Query Editor ribbon --> Add columns --> Conditional Columns

    example:

     #"Added Conditional Column" = Table.AddColumn(#"Sorted Rows", "Custom", each if Text.Contains([Fee Type], "Revenue") then [Fee Type] else if Text.Contains([Fee Type], "RRR") then [Fee Type] else null)

    you will also get a nice dialog box to customize the inputs

     

     

    Thanks & Regards,
    Mohammed Adnan

    Learn Power BI: https://www.youtube.com/c/taik18

motionid's avatar
motionid
New Member
4 years ago

Hi mohammedadnant ,

Really appreciate you responding and providing me with the solution.

This was exactly what I needed.

 

Big thank you.

 

Cheers,

Sean.

 

mohammedadnant's avatar
mohammedadnant
Impactful Individual
4 years ago

Hi motionid 

 

Thank you for marking my answer as a solution, could you also pls give thumbs up (kudos) to the solution.

 

Thanks & Regards,
Mohammed Adnan