Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm trying to calculate the total hours but from the date November 1, Previous Year to Today.
Solved! Go to Solution.
plse try this
AA YTD Billable Hours =
VAR _ToDay = Today()
RETURN
CALCULATE(SUM(SQL[Billable]),
DATESBETWEEN(SQL[workacctperiod].[Date], DATE(YEAR(_ToDay)-1, 11,1),
_ToDay))
plse try this
AA YTD Billable Hours =
VAR _ToDay = Today()
RETURN
CALCULATE(SUM(SQL[Billable]),
DATESBETWEEN(SQL[workacctperiod].[Date], DATE(YEAR(_ToDay)-1, 11,1),
_ToDay))
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
69 |
User | Count |
---|---|
114 | |
97 | |
97 | |
73 | |
72 |