Forum Discussion

IsmaelConsult's avatar
IsmaelConsult
Frequent Visitor
3 years ago

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 ...
General Comment
IsmaelConsult's avatar
IsmaelConsult
Frequent Visitor
3 years ago


Yes, man! You are correct.
I really appreciate your help.

But my real intention is to get the stock balance from a previous date as well. For example, if the user selects March 2022, they should be able to see the exact stock balance from March 2022 of the previous year.


You get it ?

Here is the link to my model again. I have added some slicers for the year and month.

Thanks for your time.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    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.