Forum Discussion
Solved
Determine if date is between 2 dates (example 2)
v-jiascu-msft your answer to this question helped me a lot but I still have one problem. My example is a little bit different. Instead of quarters I want to append a column with user id who was absen...
I managed to solve my problem with a solution given here:
http://community.powerbi.com/t5/Desktop/Dynamically-generate-table-rows-for-each-row/m-p/101483#M4255
My apologies. :smileyembarrassed:
I thought you have 2 Tables.
One with Dates and Users.
And other one ... the absence Table
So you want to TRANsform your Absence table into that FORMAT... Right?
Zubair_Muhammad yes that's correct.
Hi Silko
Good to see this Power Query Solution
Here is a DAX solution
Go to Modelling Tab>>>New Table
NEW TABLE = GENERATE ( ALL ( AbsenceTable[User ID] ), GENERATESERIES ( CALCULATETABLE ( VALUES ( AbsenceTable[Start Date] ) ), CALCULATETABLE ( VALUES ( AbsenceTable[End Date] ) ) ) )I managed to solve my problem with a solution given here:
http://community.powerbi.com/t5/Desktop/Dynamically-generate-table-rows-for-each-row/m-p/101483#M4255