Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I have a table of data in excel as below, could you please advise how can I transform data as expected for analysis.
Thanks for your support!
Look forward to hearing from you soon.
Original data: group of 3 by product, owner and size. Some cases owner are 2 people.
Jan | Feb | Mar | |||||||||||
Factory | W1 | W2 | W3 | W4 | W5 | W6 | W7 | W8 | W9 | W10 | W11 | W12 | W13 |
South Factory | Table | Table | Chair | Table | |||||||||
Jack&Joe | Joe | Jack | Jessica&Jack | ||||||||||
Small | Small | Large | Large | ||||||||||
Chair | Table | Chair | Table | ||||||||||
Joe | Jessica&Carol | Jessica | Marry | ||||||||||
Large | Large | Large | Small | ||||||||||
North Factory | Chair | Chair | |||||||||||
Carol | Joe&Marry | ||||||||||||
Small | Large |
I have data about size and list of owner:
Owner | Size |
Jack | Small |
Joe | Large |
Carol | |
Jessica | |
Marry | |
Jack |
Please advise how can I get data as below:
Factory | Month | Week | Product | Owner | Size |
South Factory | Jan | W2 | Table | Jack&Joe | Small |
South Factory | Jan | W3 | Chair | Joe | Large |
North Factory | Jan | W4 | Chair | Carol | Small |
South Factory | Feb | W5 | Table | Jack | Small |
South Factory | Feb | W6 | Table | Jessica&Carol | Large |
South Factory | W8 | Chair | Jack | Large |
Hi, @Anonymous
Will there be more than two product information from the same factory in the same week?
@Anonymous
Hi, Please check the attached file,
You can download the file: HERE
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy ,
The file used in report from your C:/ so I can not see the data (Screenshot 1), if I pass the link of my data, there is error below (screenshot 2). Please help to advise.
@Anonymous
The source data : https://1drv.ms/x/s!AmoScH5srsIYgYNuS6LdlDetCbna6Q?e=c4UEDY
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Can you share some sample data in CSV or Excel format?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @Fowmy ,
Please find the link of excel file as below. Appreciate your support!
https://drive.google.com/file/d/1pL-ZGGqKKPFUc0-g6lT-jaiMfyHdRLzd/view?usp=sharing
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.