Forum Discussion

aoncirto's avatar
aoncirto
Frequent Visitor
2 years ago

Sum/ Max - Calculation based on date [Stock calculation]

Hello all,    I am totaly new one with PowerBi DAX function. I already have it one post ( solved ) but now need the upgrade the function but dont know how to achiev. All the Dates values are in fo...
Need Help
aoncirto's avatar
aoncirto
Frequent Visitor
2 years ago

Greetings all, 

 

I just modify the original one funtion to this: 

Total_Demand_CurrentWeek = CALCULATE(SUM(
    Planning_Material_Delfor[Column]), 
    FILTER(ALL('Calendar'[Week Offset]),'Calendar'[Week Offset] >= 0)
    )

 

But can someone help me there, why its just same value like in column

"Planning_Material_Delfor[Column]" ( In that column i have it at 13/11/2023 - 76pcs and that measure show 76pcs. but the correct result is 52 + 76 = 128 because week before (06/11/2023) is there 52pcs. 

 

Thank you