DAX Loop

[dataguy2022]

Hello! I am very new to Power BI but Have a question. 

Need help on a loop or if statement that helps me do the following. Matches dates in a row, names in a row, and reponse codes in a row to deliver either a pass or failed. So if there are no matches it should be a fail. Need to do this Power BI Please.

The Dax should have 3 matches:

1. On the Date Time Column: Match the dates

2. Person Name: Name should match

3.  Response: Code Should Match

4. If all of these match then Success otherwise Fail 

[ribisht17]

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series

[v-xiaotang]

Hi @dataguy2022 

Thanks for reaching out to us.

I just want to confirm if you resolved this issue? If yes, you can accept the answer helpful as the solution or share you method and accept it as solution, thanks for your contribution to improve Power BI.

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[ribisht17 · Accepted solution]

hi   @dataguy2022 

 1. CONCAT - date, person name, and response code

1) Syntax

The basic syntax of the Power BI CONCATENATE function is as follows:

CONCATENATE(<text1>, <text2>)

2. Count the number of CONCAT per person using ALLEXCEPT

Solved: Group BY and COUNT - Microsoft Power BI Community

3. Wherever you have 1 means fail

Use If statement here

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !! PL 300 Certification Series