New Field Formula

[Kunal_Epigeeus]

Hi Community Members,

I am new to Power BI and faccing issue to write below logic in Power BI to create new custom column.
Can someone help please me to create the below logic for Power BI 

if [Insure] not contains 'Mosaic' and [binding agrement] ='TME' Then 'TME'

elseif [Insure] contains 'Mosaic' and pbinding agrement]='NON TME' Then 'NON TME

elseif  [binding agrement] ='505' then '505'

else "blank'

END

[Kunal_Epigeeus]

Thanks @amitchandak for your response and sharing the right solution

[amitchandak · Accepted solution]

@Kunal_Epigeeus ,Code for new columns in Power Query and DAX

Code in power query

if Text.Contains([Insure], "Mosaic") = false and [binding agreement] = "TME" then "TME"
else if Text.Contains([Insure], "Mosaic") and [binding agreement] = "NON TME" then "NON TME"
else if [binding agreement] = "505" then "505"
else "blank"

Code in DAX

Category =
SWITCH(
TRUE(),
NOT CONTAINSSTRING([Insure], "Mosaic") && [binding agreement] = "TME", "TME",
CONTAINSSTRING([Insure], "Mosaic") && [binding agreement] = "NON TME", "NON TME",
[binding agreement] = "505", "505",
"blank"
)