Finding Multiple values in columns and rows and Calculating for each value as category
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, </>