Year over year growth % for Financial Year

[Beniya_Samson]

Dear All,

   I have created a Financial Year for my Data. I want to find the Growth % For my financial year (Dynamically).I Have Attached the demo Screenshot. Kindly Go through it.

Thank you all.

[amitchandak · Accepted solution]

@Beniya_Samson , if you are already using year in visual

These measure can help

sales =SUM(Sales[Sales Amount])

Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),SAMEPERIODLASTYEAR('Date'[Date]))

when you only want at the year level you can also try

YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD('Date'[Date],"3/31"))
Last YTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESYTD(dateadd('Date'[Date],-1,Year),"3/31"))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

[Beniya_Samson]

Thank you for your reply.

I have tried the Year behind sales calculation but it still shows me error. Because SAMEPERIODLASTYEAR('Date'[Date]) instead of date i want to use my financial year column. So it

shows error. I have attached the screenshot. Is there any way to achieve it?. 

Thank you.

 I want output like this for my Financial year (Apr to March)