Forum Discussion
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...
CesiCash you are creating them as columns I am guessing, you need to create measures.
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
CesiCash can you plz share your power bi file?