Forum Discussion

Clint's avatar
Clint
Helper V
3 years ago
Solved

Matrix Table configuration problem

Hi All, Having a problem getting a matrix table structured the way I want it. I need to combine data from two tables into something like the embedded pic. The matrix table is structured so the Progr...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Clint ,

     

    Try to make the following change, however without any data is difficult to pin point the correct syntax

     

     

    Project Desc in Scope =
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Exceptions Reporting'[Description] ), BLANK (),
    ISINSCOPE ( 'Projects'[Project Name] ), MAX ( 'Projects'[Project Description] )
)

     

MFelix's avatar
MFelix
Super User
3 years ago

Hi Clint ,

 

Try to make the following change, however without any data is difficult to pin point the correct syntax

 

 

Project Desc in Scope =
SWITCH (
    TRUE (),
    ISINSCOPE ( 'Exceptions Reporting'[Description] ), BLANK (),
    ISINSCOPE ( 'Projects'[Project Name] ), MAX ( 'Projects'[Project Description] )
)

 

Clint's avatar
Clint
Helper V
3 years ago

Thank you Miguel - That did the trick.  Much appreciated.