power query quest

[Datanik]

Please help with a difficult power query problem

I have a table with a start date and an end date for the task

As a result, I want to see on a graph how many unclosed tasks I had in each week

I need to make a table like this in the power query. 

Please ask the power query gurus to help me.

[pratyashasamal]

Hi @Datanik ,
You can simply use Weeknum function. For Example :-

= WEEKNUM('Employees'[HireDate])

https://learn.microsoft.com/en-us/dax/weeknum-function-dax
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C