Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
5 years ago
Solved

Convert calculated column into measure

Hello, I have the following calculated column in a table called 'Admin':   Diff = [Quantidade]-LOOKUPVALUE( Admin[Quantidade],Admin[Código],[Código],Admin[Data], CALCULATE( Max(Adm...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    5 years ago

    Fcoatis , you may want to try,

    Delta = 
VAR __dt = MAX ( Admin[Data] )
VAR __tb =
    TOPN (
        1,
        CALCULATETABLE ( Admin, ALLEXCEPT ( Admin, Admin[Código] ), Admin[Data] < __dt ),
        Admin[Data]
    )
RETURN
    MAX ( Admin[Quantidade] ) - MAXX ( __tb, Admin[Quantidade] )

amitchandak's avatar
amitchandak
Super User
5 years ago

Fcoatis ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • CNENFRNL's avatar
      CNENFRNL
      Community Champion
      5 years ago

      Fcoatis , you may want to try,

      Delta = 
VAR __dt = MAX ( Admin[Data] )
VAR __tb =
    TOPN (
        1,
        CALCULATETABLE ( Admin, ALLEXCEPT ( Admin, Admin[Código] ), Admin[Data] < __dt ),
        Admin[Data]
    )
RETURN
    MAX ( Admin[Quantidade] ) - MAXX ( __tb, Admin[Quantidade] )

      • Fcoatis's avatar
        Fcoatis
        Post Patron
        5 years ago

        Thank you, thats it.