Forum Discussion
Helper IIINumber at a particular date
Helper IIIHow do you expand those dates to get that as cannot see a formula anywhere in DAX for epandDates?
Community Champion
In Query Editor you will see a function epandDates should really be expandDates (typo), this function is invoked in emplyeeDates table, please see the video.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
- tobiasmcbride
Thanks for that however is saying that there's an expression error upon saving - OLE DB or ODBC error (we cannot convert the value null to type Date) - think it's because some of the end dates have 'null' in them so how is it best to fix this Mariusz ?
- amitchandak
Super User
Please refer to my solution on the same lines:
Also, make sure your dates are detected as dates as they are in DD/MM/YYYY format.
- tobiasmcbride
Mariusz wondered if you had any further thoughts on this regarding the error I am getting?
- Mariusz
Sorry for the late reply.
The function that is used in the attached file is converting nulls at end date to Today's date, or else you have nulls in the start date field ( this would be more likely a data quality issue ), it should work fine.
Are you connecting to the sql server?
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn- tobiasmcbride
Hi Mariusz
Thanks for that. I do have some employees in this database with a null start date you are correct - these will be roles as yet not recruited for (i.e. we have a role outstanding but nobody yet confirmed for them and as such they have an undefined start date). Is there a way of altering that function to account for these people who have this undefined start date?
