Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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"
)
@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"
)
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |