Assign all values in a column to month

[Nanaki]

Hi,

in my Power Bi Data i have a table with month columns. 

In the column I have values in Euro.
I want to format my columns with the topic "month", so that all values in this column are assigned to this month.
Later I need to filter my values for each month.

Is it possible to format the columns or the values like that? 
Or do you have better example to how to solve this problem? 

Thanks in advance.

Best regards
Lennart

[ibarrau · Accepted solution]

Hi! Yes you can. The operation name is unpivot. You can do it under transform data menu with power query editor. Here you have an example of pivot and unpivot:

https://databear.com/power-bi-pivot-and-unpivot-columns/

Hope it helps,

[v-shex-msft · Accepted solution]

Hi @Nanaki,

You can't credit use one filter to processing multiple table fields. You can enter to query editor and do unpivot columns on your month fields to convert them to attribute and value.

Unpivot columns (Power Query) 

If you not want to change the table structure, you can duplicate the original query table and do 'unpivot columns' on the copied one. Then save back to data view and link tables with id fields.

After these steps, you can simply filter and use Dax formula to process (raw table)multiple fields values. 

Regards,

Xiaoxin Sheng

[ibarrau · Accepted solution]

Hi! Yes you can. The operation name is unpivot. You can do it under transform data menu with power query editor. Here you have an example of pivot and unpivot:

https://databear.com/power-bi-pivot-and-unpivot-columns/

Hope it helps,

[amitchandak]

@Nanaki , My Suggestion would be unpivoting this data

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

Then create a date using the month

Date = "01-" & [Month] & "2020" //seem you do have year. Change data type to date

Then you can use time intelligence with date table

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e