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

Hi,

You may downlaod my PBI file from here.  I have also simplified your measures

Hope this helps.

  • IsmaelConsult's avatar
    IsmaelConsult
    Frequent Visitor
    3 years ago

    "Good job, But I need to check the balances from previous periods as well. For example: Click on the year 2022, month of August, and be able to see the physical and financial retroactive balance.

    However, with these measures, when I filter a year and month, the data only calculates the information for the selected period."

    • 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.