Need to convert M query as Dax fuction code

[Anonymous]

@Jihwan_Kim@johnt75@amitchandak

Hi all,

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

[amitchandak]

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

[Anonymous]

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  

[v-cgao-msft]

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

[Anonymous]

Hi ,

Thanks for your response for my post actually I need my output as shown in the below screen shot 

actually here if you see , column PP contains 6 row of data and OPS contains 3 row of data .Our result should be of this row wise data 

For Example 

If PP columns matches with OPS columns then result should be "Match" else "Not Match"
and should have 6 result as a output,  because it contain only  6 row of data 

If OPS columns matches with PP columns then result should be "Match" else "Not Match"
and should have only 3 result as a output , because it contain only 3 row of data 

Remaining should be of "Blank" value

[v-cgao-msft · Accepted solution]

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!