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 Everyone,
I have a fairly complicated task where I need help. I have a task where I have a data about each product data and and how long each department took to complete their task and then compare which department takes longer to complete its task. The issue is based on certain tasks and conditions same department name appears more than one columns or rows.. For example.
Product ID ( unique) | Commercial Data Task 1 ( date to complete) | Commercial Data Task 1( department) | Commercial Data Task2 ( date) | Commercial Data Task 2(department) | Technical Data task 1( days) | Technical DataData Task 1(department) |
Apple | 10 days | sales | 3 days | marketing | 10 days | sales |
Orange | 5 days | IT | 36 days | sales | 5 | IT |
So it looks like certain tasks have same department but different times. So my task is to create a dax to find out how each department performs. in the view it will have lets say commerical data --> all the departments involved in this task and to see which department takes longer to complete their task when compared with other departments in total. The goal is make a visual where shows commerical data departments and comparing their each performance to find out which department takes longer to complete the task.
I cant use unpivot cause its one table with over 20'000 rows and more than 100+ columns
I hope this is clear enough explaination. If you can help me that would be great. LOOKing forward to hearing from you.
Best,
</>
Hi, @fusiee_
Can you share the expected result in excel to further clarify your needs?
Best Regards,
Community Support Team _ Eason
The expected result would be like following:
Sales ( All the sales days summed For commercial data tasks) : 46
Sales ( All the sales summed for Technical Data Tasks: 10
Total Sales = 56
Same structrue will be for all the departments based.. so we can evaluate how departments doing when compared with other departments under Commercial or Technical Data tasks.
Looking Forward to hearing from you.
Best,
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |