Combine calculated Tables

[Mvumelwano]

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

[v-yuezhe-msft · Accepted solution]

@Mvumelwano,

Please check DAX in the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2SMOetW7bujqd6U

Regards,
Lydia

[striker41]

HI ,

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

[Mvumelwano]

Thank you so much Lydia 🙂 . Your DAX formula is working

[v-yuezhe-msft]

@Mvumelwano,

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

Regards,
Lydia

[MBucherRedlion]

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]

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