Forum Discussion
Leap Year Weekly
Hi, I am trying to display weekly data since 2013, where each year's week begins on Jan 1. So far, I have made this work for most years, but when it is leap year, it throws the counts of the wee...
I figured it out thank you
Sarah
Hi Anonymous ，
Can you show me your sample data? I have tried in my desktop, but I didn’t find such an occasion as you mentioned.
What is shown here is normal even if there is a leap year between.
Best Regards,
Kelly
hi v-kelly-msft ,
Sorry I am new to Power BI .. what do you mean by sample data?
In 2016, there exists a Febuary 29, but in 2013, 2014, 2015, 2017, 2018, and 2019 there isn't.. I also believe there is a Feb 29 in 2020 also... with this, it throws off the grouped weeks because of the extra day... I found a work around where I removed the date of Feb 29 all together, but this also deletes the data on this day..
Thank you!
Sarah