Forum Discussion
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...
Mvumelwano,
Please check DAX in the following PBIX file.
https://1drv.ms/u/s!AhsotbnGu1Nok2SMOetW7bujqd6U
Regards,
Lydia
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.
HI, sorry for a late reply i was on leave. How do i make it a flat table ? Please note date columns are diferrent