Forum Discussion

Frequent Visitor

5 years ago

Cost Calculation Dependency

My Problem Dependency Problem Problem seems big. - I have a start cost&amount - I convert it to initial cost&amount - I have input cost&Amount from other table - I add intial and inp...

Frequent Visitor

5 years ago

The excel file and Power Bi File is attached..

Opening amount can be calculated but opening cost not, (opening cost = closing cost of previous month which calculated from previous opening cost...

https://vftr5821059-my.sharepoint.com/:u:/g/personal/mkcaglar_vftr5821059_onmicrosoft_com/EQJQKHXZR_xElZvPhA2v5VABk_F3iA-rYSRTfljkMDNMug?e=FhQaYd

The excel file

https://vftr5821059-my.sharepoint.com/:x:/g/personal/mkcaglar_vftr5821059_onmicrosoft_com/EcVgOijX0wtFj7nkFLgCd3cBq3FwAfn_rxpFrjwQNGoKag?e=tKvDKu

The post that you shared is not working because the opening cost depens previous month cloinng and consumption unit cost depends on open cost