Return value acording a date

[miguelp06]

Hi all

I have this table:

Today (01/11/2024) i want return 2022/2023.

After 10/01/2024 i want return 2023/2024.

Anyone can help me?

Thanks you all

[Anonymous · Accepted solution]

Hi @miguelp06 ,

You can try to use the CALCULATE and VALUES functions for the same purpose. Refer to below dax:

AnoAtual =
CALCULATE (
    VALUES ( dAnoLetivo[Ano Letivo] ),
    dAnoLetivo[Ano]
        = YEAR ( TODAY () ) - 2
)

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[miguelp06]

I found a solution.

First create a YEAR column based on the Data column.

Then I used the following function:

AnoAtual = LOOKUPVALUE(

dAnoLetivo[Ano Letivo],

dAnoLetivo[Ano],

YEAR(TODAY())-2

)