Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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!
Solved! Go to 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
Thanks so much, I was able to figure it out by using the function with my_date <= DATE(2023, MONTH(NOW()), DAY(NOW())).
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
Thanks so much, I was able to figure it out by using the function with my_date <= DATE(2023, MONTH(NOW()), DAY(NOW())).