Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I have table1 which has 7 columns and I would like to only get distinct name columns and provide values as per Names. Please help.
Table1:
Date | Primary Audit Name | Time Spent by Primary Audit | Secondary Audit Name | Time Spent by Secondary Audit | Tertiary Audit Name | Time Spent by Tertiary Audit |
1/31/2020 | Name1 | 2 | Name7 | 3 | Name3 | 2 |
1/31/2020 | Name2 | 3 | Name4 | 2 | Name7 | 3 |
1/31/2020 | Name3 | 3 | Name6 | 4 | Name6 | 1 |
1/31/2020 | Name4 | 2 | Name8 | 3 | Name1 | 4 |
1/30/2020 | Name5 | 5 | Name3 | 2 | Name2 | 2 |
1/30/2020 | Name6 | 6 | Name1 | 2 | Name8 | 5 |
1/30/2020 | Name7 | 4 | Name5 | 1 | Name4 | 6 |
1/30/2020 | Name8 | 3 | Name2 | 3 | Name5 | 2 |
Output Table:
Name | Time Spent as Primary Audit | Time Spent as Secondary Audit | Time Spent as Tertiary Audit |
Name1 | 2 | 2 | 4 |
Name2 | 3 | 3 | 2 |
Name3 | 3 | 2 | 2 |
Name4 | 2 | 2 | 6 |
Name5 | 5 | 1 | 2 |
Name6 | 6 | 4 | 1 |
Name7 | 4 | 3 | 3 |
Name8 | 3 | 3 | 5 |
Any help on this regards is appreciated.
Solved! Go to Solution.
Created a new table, Renamed columns. Add data to matrix visual
https://www.dropbox.com/s/l7rob1rb10gutlm/Auditime.pbix?dl=0
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Created a new table, Renamed columns. Add data to matrix visual
https://www.dropbox.com/s/l7rob1rb10gutlm/Auditime.pbix?dl=0
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
User | Count |
---|---|
102 | |
91 | |
87 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |