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
11 months ago

HI ANBILY1 ,

Thank you for providing sample data. Please refer below output snap and attached PBIX file.

I have created M code . Please refer the Query editor.

 

 

 

 

 

 

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