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 

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

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

2 Replies

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