DATEYTD not working properly

[Anonymous]

Hello Team,

I am having an issue to calculate the budgeted sales with the below formula:

Total_budget_FYTD = Calculate(Sum(Budget[Budget_Sales]),

    (DATESYTD(Budget[Month],"31/12")))

It is giving me the budget for the full year instead of calculating it from Jan to Sept.

Is it due to the fact that my dates are in month format:

Is there a better way to calculate it?

Thank you.

Kind Regards,

Hasvine

[v-jingzhang · Accepted solution]

Hi @Anonymous 

DATESYTD function requires a Date (or Date/time) data type column for the first parameter, so you need to convert your Month column to Date data type. You can change its format to Month "mmm-yy" after that. Or you can also add a date column (e.g. Month Start Date) to the table and use this new column in the measure. 

When used as a measure, your formula works well then. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.