Specific date measure

Question

Hi everyone,I need help with creating the next measure (i´ve tried multiple things but nothing has worked so far):In the image above there´s the table i already have created. Basically i have a In Quantity (Inqty) and a YTD In Quantity. The same goes for Out Quantity. Then i have "MvtoDia" wich is the InQty- OutQty. So, what i need to do is calculate the daily stock, wich it should be something like this:&nbsp;Daily Stock on day 14= YTDMvtoDia (Evaluated "Today") - YTDMvtoDia(Evaluated day 15). In general formDailyStock on day n= YTDMvtoDia(Evaluated "Today")- YTDMvtoDia(Evaluated day "n+1").&nbsp;If anyone has any idea i´d be incredibly thankful

amitchandak · Answer

andresgl06 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format?
Appreciate your Kudos.

v-lianl-msft · Answer

Hi andresgl06&nbsp;,&nbsp;Please refer to these:https://radacad.com/calculating-stock-on-hand-using-dax-power-bi-inventory-model&nbsp;https://www.sqlbi.com/articles/inventory-in-power-pivot-and-dax-snapshot-vs-dynamic-calculation/&nbsp;If the problem persists,could you share the sample pbix via cloud service like onedrive for business?Please remove any sensitive data before uploading.&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Specific date measure

2 Replies

Related content

Make measure ignore specific filter

Measure to replace null date with specific date

Unable to create Date Dimension and Date related measures

Enter Specific Date

Specific matrix