cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Syndicate_Admin
Administrator
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
amitchandak
Super User IV
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!

View solution in original post

1 REPLY 1
amitchandak
Super User IV
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!

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

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

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

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.

secondImage

Experience what’s next for Power BI

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