Solved: Salesdata not in machine readable format

ThomasSan · ‎01-07-2022

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?

smpa01 · ‎01-07-2022

@ThomasSan you can unpivot the data in PQ

========================
Did I answer your question? Mark my post as a solution!
Proud to be a Super User
My Custom Visualization Projects
• Plotting Live Sound: Live Sound
• Beautiful News: Women in Parliament, Energy Mix, Shrinking Armies
• Visual Capitalist: Working Hrs
• Others: Easing Graph, Animated Calendar
MayViz Submissions
• Week 1: View
• Week 2: View
• Week 3: View
• Week 4: View
========================

View solution in original post

ThomasSan · ‎01-11-2022

Cool! Thank you for your help!

smpa01 · ‎01-07-2022

@ThomasSan you can unpivot the data in PQ

========================
Did I answer your question? Mark my post as a solution!
Proud to be a Super User
My Custom Visualization Projects
• Plotting Live Sound: Live Sound
• Beautiful News: Women in Parliament, Energy Mix, Shrinking Armies
• Visual Capitalist: Working Hrs
• Others: Easing Graph, Animated Calendar
MayViz Submissions
• Week 1: View
• Week 2: View
• Week 3: View
• Week 4: View
========================