Forum Discussion
ThomasSan
4 years agoHelper IV
Salesdata not in machine readable format
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?
ThomasSan you can unpivot the data in PQ