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")))   ...
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.

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.