Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
labuser1235
Helper IV
Helper IV

Distinct column name values from 3 columns and lookup for values

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:

DatePrimary Audit NameTime Spent by Primary AuditSecondary Audit NameTime Spent by Secondary AuditTertiary Audit NameTime Spent by Tertiary Audit 
1/31/2020Name12Name73Name32
1/31/2020Name23Name42Name73
1/31/2020Name33Name64Name61
1/31/2020Name42Name83Name14
1/30/2020Name55Name32Name22
1/30/2020Name66Name12Name85
1/30/2020Name74Name51Name46
1/30/2020Name83Name23Name52

 

Output Table:

NameTime Spent as Primary Audit Time Spent as Secondary Audit Time Spent as Tertiary Audit 
Name1224
Name2332
Name3322
Name4226
Name5512
Name6641
Name7433
Name8335

 

Any help on this regards is appreciated.

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

2 REPLIES 2
amitchandak
Super User
Super User

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

Thank you so much @amitchandak . Just what I needed for now. 

 

PFB the screenshots for reference.

 

Audittime-1.PNGAudittime-2.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.