Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello,
I created a table to list assignments. But whenever the assignment has two or more resources, it shows up twice or based on the number of resources assigned to the assignment in the table. I know this makes sense as not all resources might finish assignment at the same time. Any idea how I can make it show just once? This is throwing off the count of assignment completed or ontrack. I also don't want to show it twice in the table. See example below. Data source is from Project Online.
I found out. I went to transform data. Right-click the Mapping Name column and select Delete Duplicate Data. Thank you all.
Hi @amaoa ,
I'm glad that you solved the problem by yourself. Would you please accept your own reply as answer to help the other members find it more quickly?
Best Regards,
Dedmon Dai
Hi @amaoa
Since the data in the two rows is different aside from the task name, you have to apply some kind of summarization to the date fields (and possibly the % complete) to knock it down to 1 row.
Summarizations available for dates are Last (Latest), First (Earliest), and Count. Which one you use depends on what you are trying to show.
Hope this helps
David
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
89 | |
84 | |
76 | |
64 |
User | Count |
---|---|
148 | |
115 | |
110 | |
102 | |
95 |