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.
Hi,
The solution is probably easy, but I can't get it to work as the outcome is not the same if I manually calculate.
I have an excelsheet covering the following:
Article nr | Article group | 0-30 number | 0- 30 value | 31-60 number | 31-60 value | 61-90 number | 61-90 value |
001 | Article name | 1 | € 10,50 | 5 | € 52,50 | 2 | € 21 |
I would like it to look like:
Article nr | Article group | Age | Number | Value |
001 | Article name | 0-30 | 1 | € 10,50 |
001 | Article name | 31-60 | 5 | € 52,50 |
001 | Article name | 61-90 | 2 | € 21 |
Could someone help me with this please? When I tried unpivotting I got duplicates and when I tried to remove those I apparantly removed too much as the total sum did not match the excelsheet anymore.
Thanks in advance.
Solved! Go to Solution.
Hi @lekkerbek ,
Please follow the below steps to acheive your request.
Fig 1.1:
Fig 1.2:
Fig 1.3:
Fig 1.4:
Best Regards,
Mail2inba4
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @lekkerbek ,
Please follow the below steps to acheive your request.
Fig 1.1:
Fig 1.2:
Fig 1.3:
Fig 1.4:
Best Regards,
Mail2inba4
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you both @Anonymous and @Tahreem24 for your time to help me. Much appreciated.
You want something like below screen shot? (I tried to replica your requirement at my side)
Please Give KUDOS to my post and accept this as a solution if it helps you!
Yeah, the Number Column is nothing but the Value column.
The number column should reflect the number of articles in stock. The value column reflects the total value of the stock of that article. Those two can't be combined into one column.
Can you please give screen shot or upload Excel with sample data?
I seem to be unable to upload an excelfile, so I included a screenshot in the opening post (and also here).
Hi @lekkerbek ,
I replicated your scenario at my end. Let me know if I missed anything.
Please dont forget to give KUDOS!
Input:
Output:
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.
User | Count |
---|---|
110 | |
94 | |
80 | |
67 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |