Forum Discussion
DAX Loop
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
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
3 Replies
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 SeriesHi 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.
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
