How to write the measures

[Anonymous]

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")

④

⑤

................

[v-henryk-mstf · Accepted 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.

[Anonymous]

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!