Forum Discussion

RGR's avatar
RGR
Frequent Visitor
3 years ago

Dynamic date

Hello everyone, I would like to ask the questions below, maybe someone can help. I have a table with the min & max outdoor temperature per day (since 1961). What I would like to display is the f...
Need Help
v-xiaotang's avatar
v-xiaotang
Community Support
3 years ago

Hi RGR 

Thanks for reaching out to us.

>> 

What I mean is that on 07-12-2022 automatically the calculation is done for:

-1- Avg. max temp. 01-12-2022 untill 06-12-2022 (this year)
-2- Avg. max, temp. 01-12-2021 untill 06-12-2021 (last year)

you can use EDATE() function, here is its tutorial,

EDATE function (DAX) - DAX | Microsoft Learn

 

 

Best Regards,

Community Support Team _Tang

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