Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DATEYTD not working properly

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

General Comment
Need Help
Show and Tell
Tips and Tricks
  • v-jingzhang's avatar
    v-jingzhang
    4 years ago

    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.

1 Reply

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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.