Forum Discussion

Mvumelwano's avatar
Mvumelwano
Icon for Helper I rankHelper I
8 years ago
Solved

Combine calculated Tables

HI All

 

Please help me , I would like to combine two calculated tables / summary tables, in order to have a single table that i can use in Power KPI Matrix chart (Custom Visual).

 

Example (attached Picture) I combined Table A&B to get Table C.

 

Please assist

 

 

 

 

 

Need Help

6 Replies

    • Mvumelwano's avatar
      Mvumelwano
      Icon for Helper I rankHelper I
      8 years ago

      Thank you so much Lydia :) . Your DAX formula is working

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Mvumelwano,

        If your issue is solved, you can accept my replies as answer to close  this thread.

        Regards,
        Lydia

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      HI ,

       

      I've the almost the same case like in this topic but you DAX file is missing. Could you share it once again ??

  • MBucherRedlion's avatar
    MBucherRedlion
    Regular Visitor
    8 years ago

    I believe you can just Merge Table A and B using  Date, Level 1, Level 2, and Level 3. This should make it a flat table, unless you are asking for it to have gaps like in your image.

    • Mvumelwano's avatar
      Mvumelwano
      Icon for Helper I rankHelper I
      8 years ago

      HI, sorry for a late reply i was on leave. How do i make it a flat table ? Please note date columns are diferrent