Supply Chain Dashboard
Budget: ₹600 – ₹1,500 INR
I am stuck in a DAX formula, calculating the Annual same quantity for the years 2019-2020-2021.
However I did try to solve it using the following formula but was not able to do it.
Annual Sale Quantity = CALCULATE(
sum('Past Orders'[Order Quantity]),
FILTER('Past Orders',
'Past Orders'[SKU ID]=Stock[SKU ID] &&
'Past Orders'[Order Date]>=today()-365))
However I did try to solve it using the following formula but was not able to do it.
Annual Sale Quantity = CALCULATE(
sum('Past Orders'[Order Quantity]),
FILTER('Past Orders',
'Past Orders'[SKU ID]=Stock[SKU ID] &&
'Past Orders'[Order Date]>=today()-365))