Forum Discussion
Fro88er
Helper IV
5 years agoDate and Name Table that grows
There are two tables, Date and Users. I am trying to create a third table or virtual table, of Month Start Dates, and User Names for each month. I can then add a column or measure of Phone calls, a...
- 5 years ago
In Power Query, start with the Date table. Add a custom column. In the formula box, put the name of the User Table. It should autocomplete the name.
On the next step, expand the column from the icon in the heading.
That should be it.
HotChilli
Community Champion
5 years agoIn Power Query, start with the Date table. Add a custom column. In the formula box, put the name of the User Table. It should autocomplete the name.
On the next step, expand the column from the icon in the heading.
That should be it.