cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Arsonslwrd Visitor
Visitor

Inventory on a specific date

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:

 

 

datamodel.png

 

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Inventory on a specific date

@Arsonslwrd 

 

It seems that you may simply add ALL Function.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Community Support Team
Community Support Team

Re: Inventory on a specific date

@Arsonslwrd 

 

It seems that you may simply add ALL Function.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,332)