How to count daily usage

[FrankWeng]

Hi:

Please if someone can help, as below table I have to count materials daily stock Qty.

How to write a formula in BI to get each material daily usage?

Ex, Item A usage on 3/18 = 3000-2500=500

[Anonymous · Accepted solution]

Find the solution here:

https://1drv.ms/u/s!ApyQEauTSLtOgYM7dKfyqO1PXHHdew?e=aVPNdv

Inspect the data and the model thoroughly.

Best
D

[az38]

Hi @FrankWeng 

try a measure

Measure = 
calculate(MAX('Table'[daily stock Qty]),ALLEXCEPT('Table','Table'[Item],'Table'[Date])) 
- 
calculate(MIN('Table'[daily stock Qty]),ALLEXCEPT('Table','Table'[Item],'Table'[Date]))

[FrankWeng]

@az38 

Thanks for help, but it's still not working.

Do you find any mistake from me?

[az38]

@FrankWeng 

in your screnshots I see the only row per day for each Item

Date field is the Date or Datetime?

[FrankWeng]

@az38 

Hi, the date field is pure Date type. Would be possible I send you the .pbix file?

[az38]

@FrankWeng 

share pbix-file to cloud is always the best idea