Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Pizcatella
New Member

Help with custom column displaying a values if the conditions are met.

Hello!

 

I have some rates on a table.  Column [RATE] which only has two different value choices (RateA and RateB) and column [FUEL] which has currency value of the fuel cost. I want the custom colum to display the value of [FUEL] if the value of [RATE] is RateA ortherwise just be null.

 

thanks for your time.

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @Pizcatella ;

You can add a conditional column  in power query such as:

vyalanwumsft_0-1666770047930.png

The final show:

vyalanwumsft_1-1666770072569.png

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkosSXVU0lGyUIrVQfAsUXiGBnCuE5BrZIbCNTRWio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [RATE = _t, FUEL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"RATE", type text}, {"FUEL", Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [RATE] = "RateA" then [FUEL] else null)
in
    #"Added Conditional Column"


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @Pizcatella ;

You can add a conditional column  in power query such as:

vyalanwumsft_0-1666770047930.png

The final show:

vyalanwumsft_1-1666770072569.png

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkosSXVU0lGyUIrVQfAsUXiGBnCuE5BrZIbCNTRWio0FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [RATE = _t, FUEL = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"RATE", type text}, {"FUEL", Int64.Type}}),
    #"Added Conditional Column" = Table.AddColumn(#"Changed Type", "Custom", each if [RATE] = "RateA" then [FUEL] else null)
in
    #"Added Conditional Column"


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

KT_Bsmart2gethe
Impactful Individual
Impactful Individual

Hi @Pizcatella ,

 

Do we only have the rate and cost? What is the logic to assessing whether it is Rate A or B?

 

Regards

KT

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors
Top Kudoed Authors