Hi Guys, Birthday.xlsx (17.4 KB) I am trying to calculate the number of days till the next b-day in the query editor. I run into an issue if the person has the bday on 29/02. Could you please help me to resolve the issue? Please find the attached file. Thank you, Mateusz

Hi @Matty , Give something like this a go, just paste the code in a New Blank Query. You didn’t state how you wanted to handle birthdays on the 29th so I moved them a day forward. let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("TcfJCQAgDATAXvJ2YRPP1BLSfxuKfoT5TIRQcX…

Calculate next bdays

Power Query

Melissa April 17, 2021, 7:04am 8

Hi @Matty,

I’ve created a post on that, you can find it here:

1 Like