Report Portal

International year_end_date for YTD functions in DAX

If you used the DATESYTD and TOTALYTD functions in DAX, you might have noticed that the optional parameter year_end_date is a string defining the last day of the year. The default is December 31, so this parameter is used only when the end of the fiscal year does not correspond to December 31.

For example, you can write a formula for the YTD calculation of a fiscal year starting on June 30th this way:

Read more...

 

Tags: dax, tabular

 

2007-2015 VidasSoft Systems Inc.