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

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