Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I've got a table that represents the hours of work of some employees.
It contains the name of the employee, the start date and time and the end date and time:
My intent is to duplicate each row to obtain a row containing the starting date and a row containing the ending date of each employee, something like this:
Because my intent is to create a relation between Table.DateStart and the Calendar Table. Do you know how can I do it, using Power Query? Thank you so much.
Solved! Go to Solution.
So before merging column create conditional column to check if DataStart <> DataEnd if true then merge : DataStart & "|" & DataEnd else null
And now split this conditional column !
In Power Query :
- Merge DataStart and DataEnd into one column with pipe ("|") delimiter for example
- Split this column on row (not column)
You should get what you want
@freginier thank you so much, it works!
But I have another problem: if I wanted to "split" only the rows where DataStart is different from DataEnd?
The ideal result would be this:
Thanks.
So before merging column create conditional column to check if DataStart <> DataEnd if true then merge : DataStart & "|" & DataEnd else null
And now split this conditional column !
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |