Forum Discussion

rishirajdeb's avatar
rishirajdeb
Advocate I
2 years ago

Implementing allocation logic in Power BI

Hi All,   I have to create a solution in Power BI (it's even fine to combine other Power Platform components, i.e., Power Apps & Power Automate if required). The source data contains sales amounts ...
Need Help
rishirajdeb's avatar
rishirajdeb
Advocate I
2 years ago

Attaching the data for convenience.

 

Source table:

 

countrycategoryquantityPOStransaction datetransaction id
USA123 02-05-20235064
USA156 02-05-20235406
USA178 03-05-20231878
USA143 03-05-20236842
USA1200 09-05-20233181
USA1100 09-05-20236259
USA220012309-05-20239568
USA230045609-05-20234930

 

Required output:

 

countrycategoryquantityPOS1POS2Certificate
USA12323 123
USA15656 123
USA17878 123
USA14343 123
USA1200 200456
USA1100 100456

 

If required, an Index column can also be added to the source data.

 

Thanks.