Deducting a measure per weeks

[nivanovic]

New here, I need help please to sort out simple cumulative estimated inventory measure. Measure is Location Inventory + Open PO per week - Measure Sales/w (12w).  (See screenshot below)

When I try to deduct measure sales /w (12 w) I don't get the amount deducted per each week line. Can I do it in DimDate Table since I have all weeks there?

Your help will be much appreciated.

I need helpInventory + Open PO - Average sales per WeekSame I need here Avg Sales/12w deducted by measure per week

[v-danhe-msft]

Hi @nivanovic,

Due to I could not reproduce your data structure, could you please share the pbix file to have a tets?

Regards,

Daniel He

[nivanovic]

Could you please tell me how can i send pbix file here?

I'm new here, just wanted to deduct emasure per each row (weeks), which currently I'm not able to do.

Thanks

Nikola

[v-danhe-msft]

Hi @nivanovic,

You could upload your report to your OneDrive or Dropbox and send the link to me.

Regards,

Daniel He

[nivanovic]

Hi Daniel,

Can I please send you the report via email ?

It's an urgent report to me, and I'm still stuck with Cumulative Formula.

Thank you

Nikola

[nivanovic]

Hi Daniel,

Please refer to the link below.

https://onedrive.live.com/?id=A440937A0B59E9F1%21104&cid=A440937A0B59E9F1

You will se that I need cumulative starting from current week. 

Current Week = Location Inv - Forecast

and then we have previous week - Forecast cumulative

Can you help please?

Kind regards,

Nikola