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
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Thank you.  That is a new requirement.  Not in any previous post have you mentioend that.  Explain your new requirement very clearly.  Show the expected result. 

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.