Solved: Calculate Total of Weeks between two Dates

Rigolleto · ‎02-26-2020

Hi,

I need some M code in order to calculate the number of weeks between to dates, someone could help me how can I handle this issue, also I was able to handle this using DAX but, I need to calculate the total weeks on Power Query side

Thanks

amitchandak · ‎02-26-2020

Refer

like

=each Duration.Days([StartDay] - [endday])/7

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

Greg_Deckler · ‎02-26-2020

Perhaps try Date.WeekOfYear([END DAY] - Date.WeekOfYear([START DAY]) + 1

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...