How to count current stock

Question

Hi,I have a simple query, on a count, but not sure which of these functions I should; Count;&nbsp;COUNTAX; I would like to accomplish below; I would like to show this month by month.Metadata:&nbsp;Bought Date ==&gt;The date&nbsp; the car was bought for sale (stock)Sold Date&nbsp; &nbsp; &nbsp; &nbsp;==&gt;The date&nbsp; car was soldReturn Date&nbsp; &nbsp;==&gt; The date car was returned&nbsp;I would like to ::::Count Cars in stock =Sold Date&nbsp;-Return date&nbsp;&nbsp;&nbsp;Expected answer:&nbsp; &nbsp;Sold 3 cars and 1 returned car = 2&nbsp; (Count Cars in stock)&nbsp; &nbsp;Please below Dummy dateCar ID&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Bought Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Sold Date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Return date (unhappy customer id)1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;01/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 11/01/20202&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;02/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 12/01/20203&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;06/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 10/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;12/02/20204&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10/01/2020&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;15/01/2020&nbsp; &nbsp;Thanks in advance&nbsp; &nbsp; &nbsp;&nbsp;&nbsp;

mariusz · Accepted Answer

Hi&nbsp;MYDATASTORY&nbsp;
&nbsp;
You can create a date dimension ( if you haven't got one ) create relationships between all dates and later use&nbsp;USERELATIONSHIP function in your measures to count the events.
&nbsp;
Date dimension example
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
&nbsp;
USERELATIONSHIP
https://docs.microsoft.com/en-us/dax/userelationship-function-dax
&nbsp;

Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me. LinkedIn

Forum Discussion

How to count current stock

2 Replies

Related content

Inventory and Stock balance calculation

stock ageing

Counting nulls

stock ageing

Stock quantity counting help