Forum Discussion
Wrong Total
How can i fix my total in a matrix. The expresions are: Saldos:= CALCULATE(SUM(Saldos[Entrada])-SUM(Saldos[Saida])) Estoque:= VAR DATAINI=FIRSTDATE(ALL('Calendar'[Data])) VAR ...
Here is the link to my model again. I have added some slicers for the year and month.
Thanks for your time.
https://drive.google.com/file/d/1SRLaszxsVbKNi70vtu7A9QqzRsVd9tr4/view?usp=share_link
Hi,
Use this measure to get the stock value in the same month last year
Inventory value in SPLY = CALCULATE([Inventory value],SAMEPERIODLASTYEAR('Calendar'[Data]))Hope this helps.