cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Anonymous
Not applicable

## How to write the measures

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

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

1 ACCEPTED SOLUTION
Community Support

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.

2 REPLIES 2
Community Support

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
Not applicable

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!