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,
Because of the context. The context of Total is the whole "Region_1". It seems you have one project in many regions. Maybe you data looks like this:
Entered Date Region_1 Project ID 1/4/2017 Canada 1 1/10/2017 Canada 3 1/2/2017 Central 1 1/8/2017 Central 3 1/5/2017 East 1 1/11/2017 East 4 1/3/2017 NA 1 1/9/2017 NA 4 1/1/2017 South 1 1/7/2017 South 2 1/6/2017 West 1 1/12/2017 West 5
Then you can try this formula:
V2 YTD Project Creation =
SUMX (
SUMMARIZE ( 'Detail', Detail[Region_1], "YTD P C", [YTD Project Creation] ),
[YTD P C]
)
Best Regards!
Dale