Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I would like to transform my Excel report to the Power Bi and am struggling with Month over month view. I have found some tutorials, but it was always been MoM in rows, I need the months in columns and I want to manually select which months Ito compare against each other. My images from Excel and power BI are below.
Could you please help me with this?
Thank you
Excelent, it was two hard days trying to copy your solution but, I finally did it.
One more thing. Is it possible to add € to the month columns?
Thank you very much
Hi @Nosal ,
What you're trying to achieve cannot be done out of the box but possible with some advanced DAX. You will need a disconnected table that holds the month names + another row for the Difference and then use the measures to show the value depending on whether the row contains the month name or if refers to the difference. Use dynamic string format for the value formatting. The disconnected table can have this information. Please see screeenshot below and sample pbix
Proud to be a Super User!
User | Count |
---|---|
93 | |
87 | |
77 | |
72 | |
67 |
User | Count |
---|---|
116 | |
107 | |
88 | |
65 | |
63 |