Calculate Total of Weeks between two Dates

[Rigolleto]

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 · Accepted solution]

Refer

like

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

[Greg_Deckler · Accepted solution]

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

[amitchandak · Accepted solution]

Refer

like

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