Forum Discussion

ANBILY1's avatar
ANBILY1
Frequent Visitor
1 year 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
    1 year 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.

jgeddes's avatar
jgeddes
Icon for Super User rankSuper User
1 year ago

I am not sure you will be able to do 100% of what you need within Power Query, but here is an example in the attached pbix file of what might be possible using your example data. (Note, I moved the municipal holiday by a couple of days just for the example.)
Schedule remains as your example data.
Auditor table as follows...

Supplier table as follows...

Results of a Supplier audit schedule...

Final Schedule result...

Hope this gets you pointed in the right direction.

  • ANBILY1's avatar
    ANBILY1
    Frequent Visitor
    1 year ago

    Congratulations, it really helped a lot.

    Only the municipal holiday section should be tailored to each auditor's state of residence, meaning it only counts as a holiday for the auditor who lives in that state. But the auditor's table example I sent didn't show this.

     

    Above is the table with the auditors and their respective municipal holidays, that is, it may be a municipal 
    holiday for a certain auditor and not for another.
    Your feedback was really impressive. Thank you very much.

     

    • jgeddes's avatar
      jgeddes
      Icon for Super User rankSuper User
      1 year ago

      Here is a new version that uses the concept of Auditor Holiday table. (I added a line to your example data to test the functionality against the existing example data.)

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        1 year ago

        Hi  ANBILY1  ,
        Thanks for reaching out to the Microsoft fabric community forum. 

         

        I would also take a moment to thank  jgeddes  , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference. 
        I hope the below 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