Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
hi !
I wanted to get the first TimeSheet date encoded by every employee.
Solved! Go to Solution.
Hi @fsim
ALLEXCEPT can take a mixture of column & table references for arguments 2+.
So you could write this to ensure any filters from the 'Date' table are retained:
mindate =
CALCULATE (
MIN ( TS[msdyn_date] ),
ALLEXCEPT ( TS, TS[msdyn_bookableresource], 'Date' )
)
Does this achieve the result you are wanting?
Regards,
Owen
Hi @fsim
ALLEXCEPT can take a mixture of column & table references for arguments 2+.
So you could write this to ensure any filters from the 'Date' table are retained:
mindate =
CALCULATE (
MIN ( TS[msdyn_date] ),
ALLEXCEPT ( TS, TS[msdyn_bookableresource], 'Date' )
)
Does this achieve the result you are wanting?
Regards,
Owen
it worked.
I don't know why I wanted to add a column instead of a full table. Thank you !
User | Count |
---|---|
57 | |
22 | |
21 | |
19 | |
16 |
User | Count |
---|---|
87 | |
87 | |
52 | |
37 | |
23 |