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] )

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.