Date rows as columns

[Anonymous]

Hi everyone,

I have a table with 2 different date columns: "as of date", "prod. date". It also contains a first column with multiple clients and columns for different types of products, as shown in the screenshot.

How can I create a separate table filtering for Type 1,  where the dates in column "as of date" appears as column headers, after the column 3: "prod. dates"  e.g. 10/29/2019 .. 10/30/2019.. 10/31/2019.. having hundreds columns of dates?

Thanks,

[santhoshcheran]

For creating pivot tables in powerbi, matrix visual comes in handy.

Check the below documentation for more:

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

[Anonymous]

Thanks @santhoshcheran . A matrix visual won't work for me since I will do multiple further calculations in new columns, based on the desired table, and it will be connected with others. Any ideas for a separate table?

[Ashish_Mathur]

Hi,

Share your desired Table structure.

[Anonymous]

Hi @Ashish_Mathur , please find below the link for the table structure.

https://drive.google.com/open?id=1BjPfE6Vf2Hp8-MEjQLrNzDHBXu6vU6mn

Since I will do multiple calculated columns, the desired table looks something like this, filtering for Product Type 1A. The dates shown as columns, are the ones from "as of date" field.

Thanks for checking!

[Ashish_Mathur · Accepted solution]

Hi,

You may download my PBI file from here.

Hope this helps.

[Anonymous]

Thank you @Ashish_Mathur ! The method provided worked for me!

[Ashish_Mathur]

You are welcome.

[JosefPrakljacic]

Hey @Anonymous ,

I hope that Ive understood you right. You can use the matrix visual and have the date column in the columns section. Then you can slice how ever you want.

If this solution doesnot help you maybe you could provide a more detailed explanation.

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria

[Anonymous]

Hi @JosefPrakljacic . Thanks for your reply.

I miss to mention that I would need the results in a new table, so I can calculate different columns on it, like averages, multiplications etc. Those calculations from the new table, and others, relate will feed a final matrix visual.

[JosefPrakljacic]

Hey @Anonymous,

you need to know that calculated tables are preprocessed changing the columns by a slicer wouldn't have any affect to the calculated table. So your newly generated columns actually need to be measures.

BR,

Josef