DAX How to Return Value Based on Business Logic

Question

I have a data set that is pulled together from different sources, but on one table. I need a formula that will help me evaluate and choose the correct column.

3 Text Columns

USI
4Ever_Code
Kit_Code

The columns could all have values in them or could all be null. I want to create a final column called Final_Code that follows this logic.

Test:

If 4EverB is not blank or null then supply that value for the row.
If 4EverB is blank or null the check Kit_Code if it exists use that value for the row
If both 4EverB is null or blank and Kit_code is null or blank, then the USI should be chosen for the row.

enter image description here

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community
– Community Bot, Commented Jan 22 at 4:05

Michael Anckaert · Accepted Answer · 2025-01-24 16:02:33Z

0

You should do this transformation with Power Query, you can use the following M-code:

let
Source = YourTable, // Replace 'YourTable' with your actual table name
AddFinalCode = Table.AddColumn(Source, "Final_Code", each 
    if [4Ever_Code] <> null and Text.Trim([4Ever_Code]) <> "" then [4Ever_Code]
    else if [Kit_Code] <> null and Text.Trim([Kit_Code]) <> "" then [Kit_Code]
    else [USI],
    type text
)

in AddFinalCode

answered Jan 24 at 16:02

Michael Anckaert

9611 gold badge8 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

DAX How to Return Value Based on Business Logic

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related