Forum Discussion

o59393's avatar
o59393
Post Prodigy
2 years ago
Solved

How to create a table with multiple rows and date column

Hi all   Can someone tell me how to create a table like the one below?   I only know how to create matrix with drilldowns, but the table above is different.   Here is a small data sample:...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi  o59393 

    First you need to go into Power Query and unpivot the table, select the year column and choose Unpivot Columns in the Transform tab, as shown below.

    Then click Close & Apply in the Home Tab.

     

    Next, create the Matrix as shown below.

     

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Yuliax

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi  o59393 

First you need to go into Power Query and unpivot the table, select the year column and choose Unpivot Columns in the Transform tab, as shown below.

Then click Close & Apply in the Home Tab.

 

Next, create the Matrix as shown below.

 

Is this the result you expect?

 

Best Regards,

Community Support Team _Yuliax

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.