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())).
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |