Forum Discussion

FrankWeng's avatar
FrankWeng
Frequent Visitor
6 years ago
Solved

How to count daily usage

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 ...
az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

FrankWeng 

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

Date field is the Date or Datetime?

FrankWeng's avatar
FrankWeng
Frequent Visitor
6 years ago

az38 

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

  • az38's avatar
    az38
    Icon for Community Champion rankCommunity Champion
    6 years ago

    FrankWeng 

    share pbix-file to cloud is always the best idea