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.
Hi All. I am new to PowerBI and am trying to create a dashboard and have run into a problem.
I have a table that lists project work with a list of teams in one column. In another column I have a list of teams that have completed work on that project. I am trying create a third column (Teams Work Still Remaining) in PowerBI that shows what teams still have work remaining. I have tried using if([Teams]<>[Teams Work Completed],[Teams]) and that works for projects B and C but for anywhere where Teams Work Completed has multiple teams listed like for Project A below it does not work.
Project Name | Teams | Teams Work Completed | Teams Work Still Remaining |
A | Web DBA Network | Web DBA | Network |
B | Windows DBA | Windows | DBA |
C | Unix DBA Web | Unix DBA Web |
I have searched around and have not found any answers so far. Any help is greatly appreciated.
Solved! Go to Solution.
I think I found my own answer by simply changing the way the data is received. It is a slight change of process but will eliminate the need for creating a lot of logic. Thanks for the help. Basically we will record all teams that are part of the project and remove them once the work is done rather than add them when the work is done.
You may start from Split Column By Delimiter in Query Editor.
Thank you for the response. I am trying to work with that idea now but am wondering if you could expand on your thought a little more. I think I see where you are going with this but am not 100% sure.
I think I found my own answer by simply changing the way the data is received. It is a slight change of process but will eliminate the need for creating a lot of logic. Thanks for the help. Basically we will record all teams that are part of the project and remove them once the work is done rather than add them when the work is done.
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |