Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Need to convert M query as Dax fuction code

@Jihwan_Kim@johnt75@amitchandak


Hi all,

 

Could you anybody please convert this below M query to Dax function 

 

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    Please try this.

    Result_OPS = 
SWITCH(
    TRUE(),
    CONTAINS('Table','Table'[PP],'Table'[Ops],'Table'[Image  Name],'Table'[Image  Name]),"Match",
    'Table'[Ops]=BLANK(),BLANK(),
    "Not Match"
)
    Result_PP = 
SWITCH(
    TRUE(),
    CONTAINS('Table','Table'[Ops],'Table'[PP],'Table'[Image  Name],'Table'[Image  Name]),"Match",
    'Table'[PP]=BLANK(),BLANK(),
    "Not Match"
)

     

     

    Attach the PBIX file for reference. Hope it helps.

     

    Best Regards,
    Community Support Team_Gao

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    4 years ago

    Anonymous ,
    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      this is the expected output as per my requirement
      There should two result "Result_OPS" and "Result_PP" 
      It should compare ops value against pp value per set of image and vise versa you can find it in screen shot
      I had already shared the Power query code which i can able to get the output but its not making the performance down so why i m going to dax 
      PLease help to conver the Power query to Dax function 
      If you need any furthur details please let me know  

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ，

         

        Please create two calculated columns.

        Result_OPS = 
SWITCH(
    TRUE(),
    CONTAINS('Table','Table'[PP],'Table'[Ops],'Table'[Image  Name],'Table'[Image  Name]),"Match",
    "Not Match"
)
        Result_PP = 
SWITCH(
    TRUE(),
    CONTAINS('Table','Table'[Ops],'Table'[PP],'Table'[Image  Name],'Table'[Image  Name]),"Match",
    "Not Match"
)

        The result is shown in the figure.

        Attach the PBIX file for reference. Hope it helps.

         

        Best Regards,
        Community Support Team_Gao

         

        If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

        How to get your questions answered quickly -- How to provide sample data