Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    6 years ago

    Hi,

    You may download my PBI file from here.

    Hope this helps.

JosefPrakljacic's avatar
JosefPrakljacic
Icon for Solution Sage rankSolution Sage
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      JosefPrakljacic
      Icon for Solution Sage rankSolution Sage
      6 years ago

      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