Custom Fiscal Year Calendar from manually tracked data

[jjohnson81]

I would like to set this up to graph based on fiscal year. The data is manually tracked and sent on a weekly email. So for April the data is sent in the form of week beginning: 3/31/2019, 4/7/2019, 4/14/2019, 4/21/2019, 4/28/2019....

Our fiscal year beginns in April. How can i create a custom column for month only, year only, and the graph for a KPI for the information below?

[v-lili6-msft]

hi, @jjohnson81 

Wasnt 100% clear what you were looking for,  but if this blog about how to create a custom fiscal year calendar could help you

http://danscorner4businessintel.blogspot.com/2018/09/creating-date-table-with-fiscal-year-in.html

If not your case, please share some sample data and expected output as below:

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,

Lin