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 

     

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Create a new column like

 

Switch( true(),
isblank([Maximum]) , ">=" & [Minimum] ,
isblank([Minimum]) , "<=" & [Maximum] ,
[Minimum] & "<=>" & [Maximum]
)