topic Re: Return value acording a date in DAX Commands and Tips

Return value acording a date

miguelp06 — Thu, 11 Jan 2024 09:40:37 GMT

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

miguelp06 — Thu, 11 Jan 2024 12:12:03 GMT

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 — Fri, 12 Jan 2024 07:48:19 GMT

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