topic Re: Custom Year End Date on DATESYTD in DAX Commands and Tips

Custom Year End Date on DATESYTD

andreas789 — Fri, 18 Feb 2022 14:44:23 GMT

Our fiscal year begins on the first Sunday of May.

Is it possible to have a custom year-end date (First Sunday of May - 1 Day) on DATES YTD function?

Fiscal YTD Net Sales = CALCULATE(SUM(sales[NET_SALES]), DATESYTD(periodsfulldata[Date]))

Re: Custom Year End Date on DATESYTD

Anonymous — Fri, 18 Feb 2022 16:07:37 GMT

use (endofyear) function to createyear end date

Re: Custom Year End Date on DATESYTD

v-angzheng-msft — Tue, 22 Feb 2022 04:56:19 GMT

Hi, andreas789

Yes, use TOTALYTD fuction.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Custom Year End Date on DATESYTD

andreas789 — Tue, 22 Feb 2022 17:19:48 GMT

Thanks v-angzheng-msft but since our end date is not standard each year, is it possible to get the first Sunday of May from a powerbi function?

Re: Custom Year End Date on DATESYTD

v-angzheng-msft — Wed, 23 Feb 2022 02:03:54 GMT

Hi, andreas789
Yes, try this:

Measure = var _currentYear=MAX('Table'[Year]) return CALCULATE(MIN('Table'[Date]),FILTER(ALL('Table'),'Table'[Year]=_currentYear&&MONTH('Table'[Date])=5&&WEEKDAY([Date],2)=7))

Result:

Please refer to the attachment below for details.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Custom Year End Date on DATESYTD

andreas789 — Fri, 25 Feb 2022 10:33:19 GMT

Hi v-angzheng-msft ,

Is it possible to use that measure on DATESYTD, or TOTALYTD functions?

I tried that but it seems that it only accepts constant text values.