Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi!
Given two tables A (green) and B (blue), I need to fill out column B (complete/incomplete) based on Status column in table B. (See "Table A ID" - many to one relationship from table B to A)
Table A - project
Table B - task
Every project has 3 tasks tied. If all in scope tasks are reviewed, the project is complete.
Expected Result :
Can you help me with this? My goal is to show the % of complete projects. I will be able to get the % once I fill the complete column out.
Solved! Go to Solution.
Try this:
Column = VAR __table = SELECTCOLUMNS(RELATEDTABLE('TableB'),"__status",[Status]) RETURN IF("Open" IN __table,"Incomplete","Complete")
Hi,
This picure should clarify my solution.
Try this:
Column = VAR __table = SELECTCOLUMNS(RELATEDTABLE('TableB'),"__status",[Status]) RETURN IF("Open" IN __table,"Incomplete","Complete")
Thank you so much!
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |