Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Fiscal Year to Date Table calculating to Completed Fiscal Month



Can someone please help me with a Solution to generate a Fiscal Month To Date Table for a Fiscal/Financial Year Beginning in July (Fiscal Year = 1 July to 30 June)


I only want to calculate up to the end of the last full Month and populate a table as follows without updating filters month to month


Example, if the Current Date was Mid June, I’d want to return the table shown in the picture. I have defined Fiscal Month Number in my Date/Calendar Table (July = 1, June = 12) and have set Sort Order by this to produce the this table




Super User
Super User

@Jeremyh , Try a measure like


Meausre =
var _max = if(today() = eomonth(today(),0) , today(), eomonth(today(),1-) )
var _year = if(month(_max) <=6, year(today()) -1,year(today()))
var _min = date(year,7,1)
calculate(Sum(Table[Value]), filter(Table, Table[Date] >=_min & Table[Date] <=Max))

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Thank you for your reply but it's not quite what I'm looking for. I’ve had a bit of time to rethink the approach with a clearer description for what I’m trying to achieve.

Now that I am 2 Whole Months into the new Fiscal Year (Beginning July 1st) it’s easier to show what I want.

I already have a Date Calendar with the Number of the Fiscal Month. For Example, September is the 3rd Fiscal Month



What I want is a simple Dax Statement for the [Latest Fiscal Month] so that I can use the in this following DAX




So that I can get my table to not calculate results Greater than the current Fiscal Month. Eg.



Any Help with this would be very much appreciated. Thank you

Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!