Forum Discussion

Macros's avatar
Macros
Frequent Visitor
7 years ago
Solved

Visualize Vertical Table Horizontally

Looking for a helping hand.  I've got a table that looks like this:   Project         Member 1                   John 1                   Jane 2                   John 3                   Bob ...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago

    Hi Macros ,

     

    Not sure if the order counts for anything but you can add the following calculated column to your table:

    Member ID =
"Member "
    & CALCULATE (
        COUNTROWS ( Table1 );
        ALLEXCEPT ( Table1; Table1[Project] );
        Table1[Member] <= EARLIER ( Table1[Member] )
    )

    Then add this to a matrix with this column on Columns:

     

     

    Regards,

    MFelix

MFelix's avatar
MFelix
Super User
7 years ago

Hi Macros ,

 

Not sure if the order counts for anything but you can add the following calculated column to your table:

Member ID =
"Member "
    & CALCULATE (
        COUNTROWS ( Table1 );
        ALLEXCEPT ( Table1; Table1[Project] );
        Table1[Member] <= EARLIER ( Table1[Member] )
    )

Then add this to a matrix with this column on Columns:

 

 

Regards,

MFelix