Forum Discussion
roehler
Helper I
Helper INETWORKDAYS using Date VAR
I'm trying to generate a "WorkingDays" column that calculates the NETWORKDAYS using the StartDate/EndDate values I've created in my Quarter's table. I'm not getting an error, but it's still not work...
Hi roehler
You don't need
SELECTEDVALUE.The calculated column expression is evaluated in the row context of the
Quarterstable, so you can reference columns of that table directly.WorkingDays = VAR StartDate = Quarters[StartDate] VAR EndDate = Quarters[EndDate] RETURN NETWORKDAYS ( StartDate, EndDate, 1, Holidays )
roehlerHelper I
Helper IThank you Owen, that was perfect. I had added SELECTEDVALUE after my first attempt, and without it, it didn't work for some reason, but I removed it this morning and it worked fine.