How to work with start date and end date?

[Anonymous]

Hello everyone,

I'm quite new on Power BI and I'm stuck on dealing with time period on Power Bi. For instance, I have information which are like this :

Id |  Start date   | End date

1  | 01/02/2020 | 30/06/2020

2  | 31/03/2020 | 30/09/2020

3  | 05/02/2020 | 10/07/2020

.

.

.

And I want to be able to get the number of id per week the number. For example, how many id are there during week 10 ? For instance, something like this would be great:

Week | Count

1        | 5

2        | 2

3        | 7

.

.

.

Can you help me on this?

Thank you 🙂

[Greg_Deckler]

Open Tickets - https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/td-p/409364

[Anonymous]

Hello, thank you for your answer however being quite new to Power BI, I'm still confused. If you could give me more details, I would appreciate it. Thanks again