Forum Discussion
Solved
YTD Project Count not working
I want to count the number of projects created for the fiscal year to date. My data has a Project ID column and a date entered column. Here is my DAX: YTD Project Creation =
CALCULATE(DISTINC...
Hi cnoakland
What I would suggest doing to ensure that the YTD or DatesYTD is working correctly is to ensure that you have a Date table in your Power BI Model.
The DAX Time Intelligence functions rely on there being a Date table in order to function correctly.
You can create the Date table here: https://www.fourmoo.com/2016/09/13/power-bi-how-to-easily-create-dynamic-date-tabledimension-with-fiscal-attributes-using-power-query/
Another option instead of using the DatesYTD is you could use the TOTALYTD which could also possibly give you the desired results?
Hi cnoakland,
Could you please mark the proper answer as solution or share the solution if it's convenient for you? That will be a big help to the others.
Best Regards!
Dale