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.
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
Solved! Go to 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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |