Forum Discussion

Fro88er's avatar
Fro88er
Icon for Helper IV rankHelper IV
5 years ago
Solved

Date 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...
  • HotChilli's avatar
    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.