cancel
Showing results for
Search instead for
Did you mean:
Administrator

Check stock on previous date

Hello, good morning, I need your help for the following problem:

I have a stock table that tells me the product units today.

I have another table "movimentos" that tells me for each product the inputs and outputs that you have made every day.

With a filter from the date I want to know the inventory value of the products to the date of today, I get the moves in the period,

and by difference with stock I get the inventory.

Now I need to compare that inventory with previous periods. How can I get the moves from a year ago to today, from

two years to this day?...

I try the measure:

Moviments_year-1 = CALCULATE(sum(PBI_MOVIMIENTOS[Cantidad]), PARALLELPERIOD(Calendari[Date],-1,YEAR))

But since it's out of the filter, the field is empty.

 Stock table Product Amount Product 1 5 Tabla Movimentos Product Movements Date Product 1 +2 12/08/20 Product 1 -1 15/10/20

Filter: 31/01/21 to this day

Thanks a lot.

1 ACCEPTED SOLUTION
Super User IV

@Syndicate_Admin, see how to work with the previous non-continuing date on my blog

Intelligence of the day - Last day, last day not continuous
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5c3243d...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

1 REPLY 1
Super User IV

@Syndicate_Admin, see how to work with the previous non-continuing date on my blog

Intelligence of the day - Last day, last day not continuous
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5c3243d...

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

Check it Out!

Click here to read more about the April 2021 Updates!

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors