Forum Discussion

Arnaudd's avatar
Arnaudd
New Member
2 years ago
Solved

Conditional column based on data from different rows and same user

Hello , I have the date as in the below power BI table, I want to  modify column [PassY/N] or create a new conditional column, based on the below cretaia: if there are two rows rows for the ...
Need Help
Show and Tell
  • LeandroDeodato's avatar
    LeandroDeodato
    2 years ago

    You can use the lbendlin solution, or, if you prefer in dax, can use this mensure.

     

    best regards.

     

     

LeandroDeodato's avatar
LeandroDeodato
Resolver II
2 years ago

You can use the lbendlin solution, or, if you prefer in dax, can use this mensure.

 

best regards.

 

 

Arnaudd's avatar
Arnaudd
New Member
2 years ago

Thanks lbendlin 

 

Thanks LeandroDeodato , the DAX might be easier to implement, I tested it and it works!

but, if I have anather coloumn (ex: number of test 2), and want to do the same aggregation as the one I have done to  : "number of test" , what is the correct DAX fonction to use ?

I added an extra line (Pass2) of the other coloumn but I am getting error : The syntax for '"Pass 2"' is incorrect. 

 

New_Table = SUMMARIZE('exam (Questions)',
'exam (Questions)'[username],
"Number of Tests", COUNT('exam (Questions)'[ID]),
"Pass", if(CONTAINS('exam (Questions)','exam (Questions)'[Pass(Y/N)],"Yes"),"Yes","No")
"Pass2", if(CONTAINS('exam (Questions)','exam (Questions)'[Pass(Y/N)2],"Yes"),"Yes","No")

)

 

Thanks

 

 

  • muhammad_786_1's avatar
    muhammad_786_1
    Solution Supplier
    2 years ago

    There's only 1 comma missing between "Pass" and "Pass2" lines, which causes a syntax issue.

     

    It should be like this:

    New_Table = SUMMARIZE('exam (Questions)',
    'exam (Questions)'[username],
    "Number of Tests", COUNT('exam (Questions)'[ID]),
    "Pass", if(CONTAINS('exam (Questions)','exam (Questions)'[Pass(Y/N)],"Yes"),"Yes","No"),
    "Pass2", if(CONTAINS('exam (Questions)','exam (Questions)'[Pass(Y/N)2],"Yes"),"Yes","No")
    )

     

    Best Regards,
    Muhammad Yousaf

     

    LinkedIn