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 am looking to convert the data from the bollow view to eather than having months in the columns but to have 1 column called months with multiple numbers associated with that 1 country for example;
Country Month Value
American Samoa December 5
American Samoa March 6
American Samoa April 7
Solved! Go to Solution.
Hi @Anonymous ,
Based on my test, you may use unpivot function:
Result:
Regards,
Daniel He
Hi @Anonymous ,
Based on my test, you may use unpivot function:
Result:
Regards,
Daniel He
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 |
---|---|
113 | |
100 | |
77 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |