Forum Discussion

JordanJarron's avatar
JordanJarron
New Member
1 year ago
Solved

2 Way Table

Hello everyone,   I am trying to create a two way table in Powerbi,   I have a list of projects with tenure and headcount,    The table I would like to create would have: Columns: Tenure by gr...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi JordanJarron 

     

    Thanks for the reply from danextian .

     

    Can you accept the output shown in the screenshot? If so, please refer to the following test.

     

    Sample:

     

    Create a measure as follows

    Measure = CONCATENATEX(FILTER('Table', 'Table'[Headcount Group] = MAX([Headcount Group]) && 'Table'[Tenure Group] = [Tenure Group]), [Project], ",")

     

     Then select the Matrix visualization and place the fields in the corresponding positions.

     

    Best Regards,
    Yulia Xu

     

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

danextian's avatar
danextian
Super User
1 year ago

Seems possible but no sample data test.

JordanJarron's avatar
JordanJarron
New Member
1 year ago

Here to me the important part is the result, the dataset I can rework it, 

 

You can expect raw data to be like that:

 HeadcountHeadcount GroupStart DateTenure Group
Project A30<50January 2024<1 Year
Project B80>50August 2023>1 Year
Project C120>100July 2023>1 Year
  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi JordanJarron 

     

    Thanks for the reply from danextian .

     

    Can you accept the output shown in the screenshot? If so, please refer to the following test.

     

    Sample:

     

    Create a measure as follows

    Measure = CONCATENATEX(FILTER('Table', 'Table'[Headcount Group] = MAX([Headcount Group]) && 'Table'[Tenure Group] = [Tenure Group]), [Project], ",")

     

     Then select the Matrix visualization and place the fields in the corresponding positions.

     

    Best Regards,
    Yulia Xu

     

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