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.
As shown in the picture I attached, There is one part (part no 127316) has multiple values in the next column. I want to split those values into different columns based on the same part no. 78.96% is the current month's value and 53,51% is the last month's value and I want to create two different columns as "Current month", "Last month" and split these values into these columns. I have multiple parts that have multiple percentages but some of the parts only have one percentage. The upper value (78.96% ) is the current month and the below value (53,51%) is the last months value. This is the case for the other part numbers too. My main goal is to show the data like this and calculate the difference between months if there are values for two months for a part. How can I transform the data to achieve this?
Solved! Go to Solution.
actually i don't suggest you to pivot table.
you can create a column
Proud to be a Super User!
actually i don't suggest you to pivot table.
you can create a column
Proud to be a Super User!
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 |
---|---|
103 | |
101 | |
87 | |
73 | |
67 |
User | Count |
---|---|
119 | |
111 | |
95 | |
79 | |
72 |