Skip to main content
cancel
Showing results for 
Search instead 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

Reply
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
v-henryk-mstf
Community Support
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.

View solution in original post

2 REPLIES 2
v-henryk-mstf
Community Support
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. 

forenkl_0-1671784730074.png

Does this work for you?

If it helps, please mark it as resolved and give thumbs up.

 

Thanks!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.