Forum Discussion

Quakker's avatar
Quakker
Helper II
3 years ago

Filter on multiple Columns / Values - Data Consolidation

Hi All, i´m struggeling to create a Costcenter Report, where some kind of consolidation has to be done. Attached you can see some sample data.   What i want to achieve is: If a User selects...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Quakker,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Quakker's avatar
Quakker
Helper II
3 years ago

Hi Xiaoxin,

we were still not able to find a solution.

Currently we are not sure if it is even possible to create such a measure.

I´ve attached some sample data. Unfortunatley it was not possible to upload it as a table.

Already thanks for your help and best regards!

 

COSTCENTER;AMOUNT;MONTH;SOURCEOBJECT;COSTELEMENT;CONSOLIDATION;HIERARCHY
43960654;92531,88;1;43960552;6600250000;;TOTAL_COSTS
43960654;52374,15;1;43960551;6600250000;;TOTAL_COSTS
43960654;406388,97;1;;6600260000;;TOTAL_COSTS
43960552;736;1;43960654;6520000001;;TOTAL_COSTS
43960552;684,54;1;43960655;6520000016;;TOTAL_COSTS
43960552;91111,46;1;;4020110000;;TOTAL_COSTS
;-92531,88;1;43960552;8888888888;43960654-43960552;TOTAL_COSTS
;92531,88;1;43960552;9999999999;43960654-43960552;CHARGES
;-52374,15;1;43960551;8888888888;43960654-43960551;TOTAL_COSTS
;52374,15;1;43960551;9999999999;43960654-43960551;CHARGES
;-736;1;43960654;8888888888;43960552-43960654;TOTAL_COSTS
;736;1;43960654;9999999999;43960552-43960654;CHARGES
;-684,54;1;43960655;8888888888;43960552-43960655;TOTAL_COSTS
;684,54;1;43960655;9999999999;43960552-43960655;CHARGES