Month over month in columns

[Nosal]

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 

[Nosal]

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

 

[danextian]

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