Forum Discussion
Create a new table with multiple rows for each ID based on date.
Hello everyone, and thank you in advance. I have a dataset with this general form: I am trying to generate a table that has a row for each date in between the start and end date inclus...
Anonymous
With Query EditorAdd this Custom Column
={Number.From([Start])..Number.From([End])}Now Expand it to new rows
Now convert this column into date format
Anonymous
With Query Editor
Add this Custom Column
={Number.From([Start])..Number.From([End])}
Now Expand it to new rows
Now convert this column into date format
how would I do the same thing if I only wanted EOM dates instead?
Thats awesome... curious to know how that works.. can you explain.
