Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |