Last Year Vs Actual Months

[pablofigueira]

Hi,

How can I make something like this? ( example below)

I need to have one column (last year) and months (this year) on same matrix. 

I´ve tried many things, with no result.

Thanks for help

Pablo

[BiNavPete · Accepted solution]

Hi @pablofigueira 

I answered a post with a similar solution here the other day.

The problem is not having a dimension column with just what you want. So you need to build a disconnected table with the headers on it and add a Measure using SWITCH logic.

Have a look at the other post and if it makes sense, fine. If not then please post a sample PBIX and I'll wotk it through.

Pete
Web: https://binavigation.com
Linked In: https://www.linkedin.com/in/pete-smith-955b73181