We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
Hi everyone,
I am having the problem that sales is giving me their sales figures in the following format:
Naturally, I would need to put those figures in a machine readable format with separate columns for month and year (see below) before I can properly use them in PBI.
I was searching on google and in the forum here but I was unable to find the proper answer. Can therefore anyone help me here, please?
Solved! Go to Solution.
@ThomasSan you can unpivot the data in PQ
Cool! Thank you for your help!
@ThomasSan you can unpivot the data in PQ
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 3 | |
| 2 | |
| 2 |
| User | Count |
|---|---|
| 10 | |
| 8 | |
| 7 | |
| 7 | |
| 5 |