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

[Kumar Kumar]

Dear friends

i’m having a problem to calculate the AGING balance; However i have 2 measures to calculate my aging stock and works fine with expected result (690). Whereas i wanted to merge this into one measure and i’m not getting the correct values 690 instead of 4679

Please help me, how can i get correct value (690) instead of 4679 
Sample file attached for your reference

——————————
Kumar
——————————

[Vilmar Santos]

Olá

Acho que não deu certo por que a variável não altera por ser estática. Troquei a variável _tdt por MAX(DimDate[Date]), e a variável _tmpAgeStk pela formula toda. 

——————————
Vilmar Santos
——————————
——————————————-

[Kumar Kumar]

Thank you Vilmar Santos

very much and this is what i was looking long time and i got relived

——————————
Kumar Kumar
——————————
——————————————-

[Kumar Kumar]

Dear Vilmar

Thanks for your support and it was fine to me my requirement is addressed.

i have a problem in same calculation.

I want to see by location wise then the calculation is showing incorrect; I don’t know where i’m wrong. Could you help this please

i have uploaded the same file 

–

——————————
Kumar Kumar
——————————
——————————————-

[Kumar Kumar]

please support me,

——————————
Kumar Kumar
——————————
——————————————-