Forum Discussion

CesiCash's avatar
CesiCash
Regular Visitor
8 years ago

Compare inventory yesterday vs. eom

Hi There,   I'm completly new to powerbi - and hope you can help me out.   I have a table with our inventory split down by product. What i want to do is compare yesterdays stock with the stock of...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

CesiCash to calculate last day for previous month use

 

calculate(sum(inventory), LASTDATE ( PREVIOUSMONTH ([Date])))
calculate(sum(inventory),  PREVIOUSDAY ([Date]))

 

you can compare them with if and then output the result

CesiCash's avatar
CesiCash
Regular Visitor
8 years ago

Hi Anonymous

 

Thank you for response. 

Unfortunately it doesnt work.

 

I was able to calculate a column for Yesteraday inventory:

Inventory Yesterday = CALCULATE(SUM('Product'[Trial]),'Previous Date')

 

But i could not make the second column for Last Month value:

Inventory EOM = CALCULATE(SUM('Product'[Trial]),LASTDATE(PREVIOUSMONTH(Datetable[Date].[Date])))

 

 

It always tells me "A circular dependency was detected: Product[Inventory EOM], Product[Inventory Yesterday], Product[Inventory EOM]."

 

 

What did I do wrong?

Best

Carina

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    CesiCash you are creating them as columns I am guessing, you need to create measures.

    • CesiCash's avatar
      CesiCash
      Regular Visitor
      8 years ago

      Hi Anonymous,

       

      So i calculated both as measure, but still i get just blank values for the inventory of last month.

       

      Thats how my calculation looks like: EOM = CALCULATE(SUM('Product'[Trial]),LASTDATE(PREVIOUSMONTH(Datetable[Date].[Date])))

       

      Best

      Carina

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        CesiCash can you plz share your power bi file?