Forum Discussion

Kunal_Epigeeus's avatar
Kunal_Epigeeus
Frequent Visitor
2 years ago
Solved

New Field Formula

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  i...
Need Help
  • amitchandak's avatar
    amitchandak
    2 years ago

    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"
    )

amitchandak's avatar
amitchandak
Super User
2 years ago

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"
)