Forum Discussion
Helper IIINumber at a particular date
Community Champion
You can add an extra table to your model that expand dates ( start to end ).
On the attached, you will find a file that applies this concept to your sample.
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Helper IIIHow do you expand those dates to get that as cannot see a formula anywhere in DAX for epandDates?
- Mariusz
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.
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn- 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.
