Forum Discussion
YTD Project Count not working
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
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?
