Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Condition Combining columns

Hi All,    I have a data set that looks something like this: Minimum Maximum 1   5   3 6   7 2 4    I want to create a new column in DAX so that the data will look som...
Need Help
Show and Tell
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    New column =
SWITCH (
    TRUE (),
    NOT ISBLANK ( Table1[Minimum] ) && NOT ISBLANK ( Table1[Maximum] ),
        Table1[Minimum] & "<=>" & Table1[Maximum],
    NOT ISBLANK ( Table1[Minimum] ), ">=" & Table1[Minimum],
    NOT ISBLANK ( Table1[Maximum] ), "<=" & Table1[Maximum]
)

     

    Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers 

     

AilleryO's avatar
AilleryO
Memorable Member
5 years ago

Hi,

 

You can use those functions to do the trick.

IF or SWITCH functions to test

ISBLANK([mini]) and ISBLANK([maxi]) to check if you have a value or not.

and finaly CONCATENATE (or uing &) with ">=" and "<=" symbols.

 

Hope it helps