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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Count of columns with date per person

Hi All

 

need help. i have an export of a training module program and i need to summarise the data in different reports

 

i have 200 users and over 100 training modules exported in a spreadsheet. Format of excel as below (but in a larger scale)

the training columns are not labelled as 1, 2, 3 etc, they are the names of the actual modules

if the module was completed i get a date stamp and a blank if no completion to date

 

User NameTraining 1Traning 2Training 3....Traning 100
User 112/07/2021    
User 2 12/07/202112/07/2021  
...     
User 200     


i need to summarise the data as

 

- count how many modules completed by each user
- count how many users have completed each module so i can show popular to non popular modules (somehow show this in a report/table without having to drag in 100+ columns)

thankyou in advance

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Anonymous , I know data would increase , but unpivot thee columns. Then you will have these in rows. Remove rows with blank timestamp if needed

 

https://radacad.com/pivot-and-unpivot-with-power-bi

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Anonymous , I know data would increase , but unpivot thee columns. Then you will have these in rows. Remove rows with blank timestamp if needed

 

https://radacad.com/pivot-and-unpivot-with-power-bi

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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