Forum Discussion
Date rows as columns
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 ...
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
Solution Sage
Solution SageHey 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