Forum Discussion

ANBILY1's avatar
ANBILY1
Frequent Visitor
11 months ago
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...
Need Help
  • v-menakakota's avatar
    v-menakakota
    10 months ago

    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.

v-menakakota's avatar
v-menakakota
Community Support
10 months ago

Hi ANBILY1,

Thank you for reaching out to the Microsoft fabric community forum. I reproduced the scenario, and it worked on my end. I used my sample data and successfully implemented it.

 

I am also 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.

ANBILY1's avatar
ANBILY1
Frequent Visitor
10 months ago
Dear Sir, truly exceptional.
I have one more question: is there any way to return groups of 5 free dates, as many as I have?
I added another fortnight to the initial table and noticed that it only shows the first 5 days; when 
there are 10 free days, it doesn't show 5 and 5.
That is, when there are 5 days and 5 more free days, for example, the table needs to show two groups 
of 5 days.

Thank you for your attention.