Forum Discussion

miguelp06's avatar
miguelp06
Frequent Visitor
2 years ago
Solved

Return value acording a date

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's avatar
    Anonymous
    2 years ago

    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

2 Replies

  • miguelp06's avatar
    miguelp06
    Frequent Visitor
    2 years ago

    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
    )
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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