Forum Discussion

New Member

4 years ago

Solved

Create Measure Amount with dynamic end of fiscal year using DATESYTD

Hi, I am trying to create a measure of Amount YTD. The date of end fiscal year is dynamic( it used 4-4-5 and/or 4-4-6 rule). In Dates table, each row of date had FiscalStart...

Need Help

V-lianl-msft
4 years ago
Hi QHY ,

Creating a column that contains the number of days elapsed in a year (or the running total of days in the year, if you prefer) makes it easy writing the FILTER required to use the right set of days in each calculation.

Please check if below links are helpful.

https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/

https://community.powerbi.com/t5/Desktop/Setup-a-custom-calendar-and-calculate-YTD-PTD-etc/td-p/152457

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

V-lianl-msft

Community Support

4 years ago

Hi QHY ,

Creating a column that contains the number of days elapsed in a year (or the running total of days in the year, if you prefer) makes it easy writing the FILTER required to use the right set of days in each calculation.

Please check if below links are helpful.

https://www.sqlbi.com/articles/week-based-time-intelligence-in-dax/

https://community.powerbi.com/t5/Desktop/Setup-a-custom-calendar-and-calculate-YTD-PTD-etc/td-p/152457

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