Forum Discussion
Repeat rows specific time depends on date
- 5 years ago
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
Hi selimovd
thank you for your help ,,,,,,
But its repeat the rows by day ,can i make it to repeat by month
- selimovd5 years agoMost Valuable Professional
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.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi - Syndicate_Admin5 years agoAdministrator
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 regardsDenisBlog: WhatTheFact.bi