Inventory on a specific date

[Anonymous]

Hello,

I know this question gets post here a lot but i cant seem to get it working for me.

I Have the folowin data model in SSAS tab:

The table DM_Voorraad contains the inventory data per product, per day. This data is split into total value, quantity an weight for that product at the end of the day and the differerence from the last mutation in the columns delta value, delta quantity and delta weight.

I used the formula:

Total Value = (CALCULATE(sum(DM_voorraad[Delta Value]);

filter(Fact_order;Fact_order[%key_datum]<=max('Fact_order'[%key_datum]))

))

which seems to be working fine untill i select a date. In that case this formula will calculate the sum of the mutation in the selected date period.

I need a query that either sums all the data outside the selected period up to the max selected date, OR select the latest total value for each product.

Sincerely,

Erik Venema

[v-chuncz-msft · Accepted solution]

@Anonymous 

It seems that you may simply add ALL Function.

https://www.sqlbi.com/articles/filter-arguments-in-calculate/