Forum Discussion
Switch in calendar
Hi Folks 2 things I am looking answers for if possible, the formula below returns the period based on the calendar [week]. So weeks 1,2,3,4 = period 1, 5,6,7,8 = period 2 9,10,11,12,13 =perio...
Please see if this article helps. It has a Date table created in the query editor that may work for you.
445 Calendar with 53-Week Years – Hoosier BI
Pat
Hi Pat
Brillant!!! i have just watch your Youtube video and have learnt a little bit more on my journey about Power BI and Power Query. I will use your formula going forward and adapt it to what I need but I not sure if solves my initial question. No matter what I will dig deeper into your tutorial and hopefully learn a bit more thanks again