Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

return max value within current year

Hello,   I'm a beginner with DAX and power bi, and I would appreciate your help.   Basically, I have a table with similar columns A,B,C, but I don't know how to create a formula for D.   ...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    Please refer to below calculated column.

    Max N current year =
CALCULATE (
    MAX ( Table7[N] ),
    FILTER ( ALLEXCEPT ( Table7, Table7[proj] ), Table7[year] = YEAR ( TODAY () ) )
)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Anonymous,

 

Please refer to below calculated column.

Max N current year =
CALCULATE (
    MAX ( Table7[N] ),
    FILTER ( ALLEXCEPT ( Table7, Table7[proj] ), Table7[year] = YEAR ( TODAY () ) )
)

 

Best regards,

Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
7 years ago

worked perfectly, thank you very much!

 

C.