return max value within current year

[Anonymous]

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.

Basically I have different budget versions within the same year, but I want the report to only display the latest one from the current year. Sometimes we have budgets in the system that have higher version numbers (N) than the current one for this year, so simply displaying the highest number doesn't work.

thanks!

[v-yulgu-msft · Accepted solution]

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]

worked perfectly, thank you very much!

C.

[jthomson]

Are cells D5/D6 3 rather than 2 by design?

[Anonymous]

Hi

Each project has its own versioning in Oracle. What I meant was that for P002, the highest (ie current in 2018) budget version is 3.

However for P001, the current 2018 budget version is 2 (3 is in 2019).