Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Create a new table depending on range

Hi there, I want to create a new table depending on range, I got the following data; but I want to see it the following way; Thanks in advanced.
Ashish_Mathur's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

This M code will work

={Number.From([StartDate])..Number.From([EndDate])}

Then expand this new column.

Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    The solution send me the following error

    Range3.PNG

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      5 years ago

      You are missing the curly brackets at the beginning and end.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Sorry, now I got the following error

        range4.PNG