Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi need help to create a table with a loop process where it shows the following
i have start date and end date
and a list of people
need the table with the next structure
first
print the start date and the first person in the other table
then
print the start date + one day and the same first person
once it reaches the end date then switch over to the next person and repeat the process for each of the people that we have on the second table once it reaches the limit of people then end it, it is going to show a table like this
date person
01/01/2022 john
01/02/2022 john
01/03/2022 john
01/04/2022 john
...
...
...
01/01/2022 max
01/02/2022 max
01/03/2022 max
01/04/2022 max
...
...
...
end_date last_person
Solved! Go to Solution.
You could do this with CROSSJOIN. If you have your list of people and then a list of dates (probably from a date table) then you could try
CROSSJOIN ( DATESBETWEEN ( Date_Table[Date], [Start Date], [End Date] ), People[Name] )
You could do this with CROSSJOIN. If you have your list of people and then a list of dates (probably from a date table) then you could try
CROSSJOIN ( DATESBETWEEN ( Date_Table[Date], [Start Date], [End Date] ), People[Name] )
awesome, thank you
User | Count |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |