Forum Discussion
Solved
loop function to get free dates
Dear all, thank you in advance for your collaboration.
I have the following question:
I have two tables, one for suppliers and one for auditors.
In the supplier table, I have the following colu...
Hi ANBILY1 ,
I am including .pbix file for your better understanding, please have a look into it:
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
Dear Sir, thank you again for your help.
However, the date range doesn't have to be sequential; it can start when there's a free date and
continue until there are 5. For example, if the first free date is October 3, 2025, and it's on a
Friday, you can continue on the second if there's a free date. This would then be completed with
October 6, 7, 8, and 9, 2025.
In short, it's a 5-day sequence, but it can be interspersed with Saturdays, Sundays, or holidays,
as long as there are 5 business days.
Thank you for your attention.
v-menakakota
Community Support
Community SupportHi ANBILY1 ,
I am including .pbix file for your better understanding, please have a look into it:
Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.
Thank you for using the Microsoft Fabric Community Forum.
- v-menakakota
Hi ANBILY1 ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you.
Best Regards,
Community Support Team