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 columns: s...
Need Help
  • v-dineshya's avatar
    v-dineshya
    10 months ago

    Hi  ANBILY1 ,

    Please refere below output snap and PBIX file.

     

     

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

     

     

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

Hi ANBILY1 ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

 

Regards,

Dinesh

ANBILY1's avatar
ANBILY1
Frequent Visitor
10 months ago
Dear Sir, as per the example below, I need to group by 5 blank spaces in the value column in 
relation to the date and code column, that is, 5 consecutive dates from the most recent onwards 
that have the same code.

I need to do it using power query, that is, with M language.

This is how it is now

 

This is how I need it to stay

The dates column must contain the list with the 5 dates (I will expand it later), if there is no code with five dates, for example if I have 12 lines I would have two groups of 5 and 1 with 2 then I filter and leave only those that have 5. The important thing is to separate as many as possible by group of 5.

 

Thank you in advance for your attention.

  • v-dineshya's avatar
    v-dineshya
    Community Support
    10 months ago

    Hi  ANBILY1 ,

    Please refere below output snap and PBIX file.

     

     

     

    I hope this information helps. Please do let us know if you have any further queries.

     

    Regards,

    Dinesh

     

     

     

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

      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 

      • v-dineshya's avatar
        v-dineshya
        Community Support
        10 months ago

        Hi @ANBILY1 ,

        We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

         

        Regards,

        Dinesh