Create row for each week in daterange

[JiriS]

Hi,

I want to create a report. I have dataset and by using DAX I change the dataset to the format I need.

Than it looks like that: 

Name	Personal number	Date from	Date to	Department	Type
Peter	121412	12.08.2020	24.09.2020	D1	X
George	121516	24.12.2019	01.02.2020	D2	X
George	121516	01.03.2020	05.08.2020	D1	Y

By using DAX I need to create this table:

Name	Personal number	Department	Type	Week	Year
Peter	121412	D1	X	33	2020
Peter	121412	D1	X	34	2020
Peter	121412	D1	X	35	2020
Peter	121412	D1	X	36	2020
Peter	121412	D1	X	37	2020
....

It means that I want to have for each week between daterange (from-to) one row.

How can I do that?

Thank you,

George

[amitchandak · Accepted solution]

@JiriS, I've done it for Dates in this file.

https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0

If you can week and year on your calendar. You should be able to group in the year of the week

[JiriS]

Thank you for your solution.

George