Forum Discussion
Calculated Columns With Multiple Conditions
Hai All, I am a dax learner, Asking your help to solve this problem
In the above Dax, I want to add one more condition, ie, in the activity, the log table initiative type should be "Sprint"
That means I want to add
Filter(Activity Log, Activity Log[Intiative type]="Sprint")
How to add this Condition to the above particular Dax
Hi AlanP514 ,
Please try this:
Result = calculate(if(related('talent 1 database'[user email]) = 'certification log[work email],"Yes","no"), filter(Activity Log, 'Activity Log'[Initiative type]="Sprint"))
AlanP514 -If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!
Regards,
TruptiS
1 Reply
Hi AlanP514 ,
Please try this:
Result = calculate(if(related('talent 1 database'[user email]) = 'certification log[work email],"Yes","no"), filter(Activity Log, 'Activity Log'[Initiative type]="Sprint"))
AlanP514 -If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudo 👍
Thanks!
Regards,
TruptiS