Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |