topic Re: How to count daily usage in DAX Commands and Tips

How to count daily usage

FrankWeng — Wed, 18 Mar 2020 20:00:28 GMT

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

Re: How to count daily usage

az38 — Wed, 18 Mar 2020 20:12:39 GMT

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]))

Re: How to count daily usage

FrankWeng — Thu, 19 Mar 2020 12:29:50 GMT

az38

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

Do you find any mistake from me?

Re: How to count daily usage

az38 — Thu, 19 Mar 2020 12:56:55 GMT

FrankWeng

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

Date field is the Date or Datetime?

Re: How to count daily usage

FrankWeng — Thu, 19 Mar 2020 14:45:48 GMT

az38

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

Re: How to count daily usage

az38 — Thu, 19 Mar 2020 15:19:34 GMT

FrankWeng

share pbix-file to cloud is always the best idea

Re: How to count daily usage

Anonymous — Sat, 21 Mar 2020 12:05:30 GMT

Find the solution here:

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

Inspect the data and the model thoroughly.

Best
D