Give two columns same name to be able to filter

[AlexJB]

Good day everyone,

I couldn't find an answer to the following question hopefully you guys are able to help me.

I have a table with the following sales data

product	202101	202102	202103	202201	202202	202203
1	20	10	23	24	15	20
2	30	40	40	34	40	40

As you can see some headers are related to the month in a certain year, so second column is januari 2021 after februari 2021 and so on. There are also colummns for januari 2022 and februari 2022.

Is there a possibility to make a measure to give these columns just the name 'januari' or 'februari'? I want this so I can place a filter in the report to only show data from januari, but then from 2021 and 2022. 

Hope you can help me!

[HotChilli · Accepted solution]

The usual way of deaing with this is to Unpivot all the month columns.

You can then either make the single column a date column (by adding 01 for the day and making the datatype a date OR splitting the column into Year and Month columns)