cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mvumelwano Regular Visitor
Regular Visitor

Combine calculated Tables

Tables.PNG

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

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

Re: Combine calculated Tables

@Mvumelwano,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 REPLIES 5

Re: Combine calculated Tables

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.

Moderator v-yuezhe-msft
Moderator

Re: Combine calculated Tables

@Mvumelwano,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Mvumelwano Regular Visitor
Regular Visitor

Re: Combine calculated Tables

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

Mvumelwano Regular Visitor
Regular Visitor

Re: Combine calculated Tables

Thank you so much Lydia Smiley Happy . Your DAX formula is working

Highlighted
Moderator v-yuezhe-msft
Moderator

Re: Combine calculated Tables

@Mvumelwano,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.