Forum Discussion
Solved
Date Measures Help?
I have used PBI quite a bit but started a new position where I am setting up for the first time in a long while. For some reason I am having issues with my date fuctions. Trying to get the endofthe...
I have found the reason, functions like ENDOFMONTH(), ENDOFQUARTER() and ENDOFYEAR() will only return last day in the exist column, not the real ending day. So you can modify your measure using DAX as below to achieve what you want to achieve:
Difference = DATEDIFF(TODAY(), EOMONTH(ENDOFQUARTER(Table1[Date]), 0), DAY)
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi aaron1225,
Your measure and Date Table URL's are not working. Please post more inputs to clarify your problem.
Regards,
Pradeep
Below is my date table, essentially I am trying to determin the number of days remaining in a month so using:
DaysToEndofMonth = DATEDIFF(TODAY(),ENDOFMONTH(dDate[Date]),DAY) however, this measure returns 294, which is incorrect.