Forum Discussion
Repeat rows specific time depends on date
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
Hey mohannadBZ ,
this is pretty easy in Power Query within Power BI. The following tutorial should guide you to your result:
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 regardsDenisBlog: WhatTheFact.bi
14 Replies
Hey mohannadBZ ,
this is pretty easy in Power Query within Power BI. The following tutorial should guide you to your result:
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 regardsDenisBlog: WhatTheFact.biHi selimovd
thank you for your help ,,,,,,
But its repeat the rows by day ,can i make it to repeat by month
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 regardsDenisBlog: WhatTheFact.biHey @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 regardsDenisBlog: WhatTheFact.biHey @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 regardsDenisBlog: WhatTheFact.bi
