Limiting data to to the current date a year ago

[CalebG]

I'm currently trying to compare year-over-year data in power bi so I can see how this April compared to April 2022. However, I am pulling all data from last year and this year so I'm not sure how to go about this in a table or with transforming my data. If anyone has any ideas how I could do this that would be amazing. Thanks so much!

[Ritaf1983 · Accepted solution]

Hi @CalebG ,
You should create a date table and use time intelligence functions.
Please refer these tutorials:

https://www.youtube.com/watch?v=MhYEqniwung

https://www.youtube.com/watch?v=nrjJuNbzKRA

https://www.youtube.com/watch?v=VLOHvQyCKWo

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

[Ritaf1983 · Accepted solution]

Hi @CalebG ,
You should create a date table and use time intelligence functions.
Please refer these tutorials:

https://www.youtube.com/watch?v=MhYEqniwung

https://www.youtube.com/watch?v=nrjJuNbzKRA

https://www.youtube.com/watch?v=VLOHvQyCKWo

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

[CalebG · Accepted solution]

Thanks so much, I was able to figure it out by using the function with my_date <= DATE(2023, MONTH(NOW()), DAY(NOW())).