Repeat rows specific time depends on date

[mohannadBZ]

Hi every one ,,,

i need your support and help for this issue , 

i have an information table like a below , all what i want to create new table and repeat each row depending on the two column date ( start , end )

Employee Code	Name	Start	End
1001	John	01/01/2021	15/02/2021
1002	Mohannad	01/01/2021	05/04/2021
1003	Elsener	01/03/2021	05/04/2021

i want the new table as below 

Employee Code	Name	Month	Year
1001	John	01	2021
1001	John	02	2021
1002	Mohannad	01	2021
1002	Mohannad	02	2021
1002	Mohannad	03	2021
1002	Mohannad	04	2021
1003	Elsener	03	2021
1003	Elsener	04	2021

and thank you alo 

[mohannadBZ]

Hi @selimovd 

thank you for your help ,,,,,,

But its repeat the rows by day ,can i make it to repeat by month 

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31), and then filter for day s 1.

So you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[Syndicate_Admin]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31) and then filter for the day s 1.

So, you just have to have one ticket a month.

If you need help, please let me know.

If I answered your question, I'd be happy if I could mark my post as a ✔️ solution and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[selimovd]

Hey @mohannadBZ ,

you can add a column for the day of the month (1-31) and then filter for day = 1.

Like this you should only have one entry per month.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

[selimovd · Accepted solution]

Hey @mohannadBZ ,

this is pretty easy in Power Query within Power BI. The following tutorial should guide you to your result:

How to add rows for dates between start and end dates in Power BI date range data | NateChamberlain....

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi