Forum Discussion

Fcoatis's avatar
Fcoatis
Icon for Post Patron rankPost 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] )

negi007's avatar
negi007
Icon for Community Champion rankCommunity Champion
5 years ago

Fcoatis When you use column or calculated column in your measure, you have to use it with some aggreage function like sum, max, min, count etc. 

in calculated column you can use directly column name without using aggreage function.

 

for specify solution of your problem, you may share your powerbi file.