Forum Discussion
Custom Fiscal Year Calendar from manually tracked data
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?
1 Reply
v-lili6-msftCommunity Support
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/38490Best Regards,
Lin