Count years continuously from the release date of a product

[n_braun]

Hello all,

is there a way to count years continuously from the release date of a product, so that you can compare, for example, the sales development of products not by calendar year, but by the year after the release date?

Thanks in advance for your help.

[v-zhangti · Accepted solution]

Hi, @n_braun 

As an example, your product was released on June 1.

Column:

Start Of Year = 
VAR _eoy = IF(MONTH([Date])<=5,YEAR([Date])-1,YEAR([Date]))
Return
DATE(_eoy,6,1)

Fiscal year = YEAR([Start Of Year])

Is this the result you expect?

Best Regards,

Charlotte Zhang

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

[amitchandak]

@n_braun ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.