Forum Discussion

Silko's avatar
Silko
Helper II
8 years ago
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...
Need Help
Tips and Tricks
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
8 years ago

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] ) )
    )
)