Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hi all
I have a merge table where I added columns as below.
However there are a lot of columns I need to compare, is it possible to combie the conditional columns or measures to only one by adding "or" condition?
①
= Table.AddColumn(#"Sorted Rows", "Gap1", each if [ReportDate] = [Post.ReportDate] then "No" else "Yes")
Measure 1 = IF(MAX(' Merge '[Gap1])=Yes,"Yellow","White")
②
= Table.AddColumn(#"Sorted Rows", "Gap2", each if [IssueDate] = [Post.IssueDate] then "No" else "Yes")
Measure 2 = IF(MAX(' Merge '[Gap2])=Yes,"Yellow","White")
③
= Table.AddColumn(#"Sorted Rows", "Gap3", each if [FixDate] = [Post.FixDate] then "No" else "Yes")
Measure 3 = IF(MAX(' Merge '[Gap3])=Yes,"Yellow","White")
④
⑤
................
Solved! Go to Solution.
Hi @Anonymous ,
Yes, it is possible to combine the conditional columns or measures into one by using the "OR" operator.
Here's an example of how you can do it:
Combine the three conditional columns into one column using the "OR" operator:
= Table.AddColumn(#"Sorted Rows", "Gap", each if [ReportDate] = [Post.ReportDate] or [IssueDate] = [Post.IssueDate] or [FixDate] = [Post.FixDate] then "No" else "Yes")
Use the combined column in a single measure:
Measure = IF(MAX('Merge'[Gap])=Yes,"Yellow","White")
This will give you a single measure that returns "Yellow" if any of the three conditions are not met, and "White" if all of the conditions are met.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Yes, it is possible to combine the conditional columns or measures into one by using the "OR" operator.
Here's an example of how you can do it:
Combine the three conditional columns into one column using the "OR" operator:
= Table.AddColumn(#"Sorted Rows", "Gap", each if [ReportDate] = [Post.ReportDate] or [IssueDate] = [Post.IssueDate] or [FixDate] = [Post.FixDate] then "No" else "Yes")
Use the combined column in a single measure:
Measure = IF(MAX('Merge'[Gap])=Yes,"Yellow","White")
This will give you a single measure that returns "Yellow" if any of the three conditions are not met, and "White" if all of the conditions are met.
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous
You should be able to add a custom column and use the 'or' to combine these.
Does this work for you?
If it helps, please mark it as resolved and give thumbs up.
Thanks!