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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors