Condition Combining columns

[Anonymous]

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 something like this:

Minimum	Maximum	New Column
1		>=1
5		>=5
3	6	3<=>6
	7	<=7
2	4	2<=>4

Is there any way to do this in DAX using a formula? Need help with it. Thanks a lot for the help.

[amitchandak]

@Anonymous , Create a new column like

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

[AlB · Accepted solution]

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]

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