Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Raj Singh]

Hi All,

I have created a Power Query to calculate new Project Actuals cost and need to distribute the total of budgeted amount ratio.
Can anybody suggest me calculated measure :-
for example purpose I have created a sample below pivot table

1) I have to create new measure calculation based on “sum of T&E” and distribute “Dummy Line” amount in same column (i.e. Sum of T&E).
2) logic to distribute Dummy line amount is check wherever “0” values in mentioned in “Sum of T&E column”.
3) After step 2 we need to check respective cells in column “Sum of FPP T&E Budget” and distribute “Dummy line amount in same ratio.

——————————
Raj
——————————