Calendar Year to Fiscal Year

[caitlynnguyen08]

I am trying to create a fiscal year measure out of these Fields. Can someone help me write a measure using these? I cannot add columns or tables since this is a PBI dataset. 

Thanks!

[amitchandak]

@caitlynnguyen08 , refer to my blog to create FY calendar

.Creating Financial Calendar - From Any Month
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calend...

[MattAllington]

You can't do it. You need to create your own calendar table. Read my articles here 

https://exceleratorbi.com.au/power-pivot-calendar-tables/

https://exceleratorbi.com.au/build-reusable-calendar-table-power-query/

[Fowmy]

@caitlynnguyen08 

If you are going to slice and dice by fiscal year/month then you need to have column in your date table: 
This video will be usefull in that case" https://www.youtube.com/watch?v=0peKz7XjEdw&t=67s

You say "Measure", please provide sample data and the expected results:
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon if you like this reply 🙂

YouTube, LinkedIn