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?
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.
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.
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?