Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
love
Helper I
Helper I

Returning a boolean value via Power Query M with data from multiple columns

 Hello.

 

I would like a custom column to return a boolean value depending on the data in other columns.

 

Example: If all "statuses" from one "milestone" are either "done" or "Dropped" the costum column should be TRUE. If any other status for a given milestone is present, it should return FALSE:

 

 

How can I put this into a Power Query M formula? I am stuck on how to query multiple rows (milestones) to be a variable for my custom column. Is what I am asking for possible in this data structure?

 

Thank you!

-anon

1 ACCEPTED SOLUTION

Hello.

 

Thank you for your reply @MarcelBeug.

 

I ended up finding an alternative solution. I was able to query for additional fields in my base query, one of which was an indicator for completion which makes my initial problem irrelevant and seems like the overall more elegant solution.

 

I will try to check out your proposal at a later stage out of curiousity.

 

Thanks again everybody.

-l

View solution in original post

12 REPLIES 12

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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