Salesdata not in machine readable format

[ThomasSan]

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]

Cool! Thank you for your help!

[smpa01 · Accepted solution]

@ThomasSan  you can unpivot the data in PQ