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

Custom Fiscal Calendar Table with Different Days in Months

Hello Everyone, 


I am having a really hard time trying to use the time intelligence features because our fiscal calendar is not based on a month to month basis.  We have months that start in the prior month and end before the month ends. 




Jan 12/30/2017 - 1/26/2018

Feb 1/27/2018 - 2/23/2018 

and so on.....


When i use the YTD, MTD, SAMEPERIODLASTYEAR time intelligence functions they capture the entire month. So if i want to do MTD sales for January it is pulling 1/1/2018-1/31/2018 when i need it to pull 12/30/2017 - 1/26/2018. 

I have my fiscal calendar table set up and set it as the date table and everything is good there but it will not capture the dates i need. 


How can i use the time intelligence functions on my fiscal calendar?  Is this something that cannot be done and i would have to revert to creating multiple measures (ex. for PY sales i would have to create a measure filtering out Jan) that seems a bit tedious and i am sure there is a better way to handle this. 


Any help would be greatly appreciated!

vanessafvg Super Contributor
Super Contributor

Re: Custom Fiscal Calendar Table with Different Days in Months



this guy does a lot of youtube vidoes on the topic, can't point out which one exactly, but this might be helpful

Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
hgarcia Frequent Visitor
Frequent Visitor

Re: Custom Fiscal Calendar Table with Different Days in Months

Thanks for the help, this works perfectly for YTD running totals.


Still running into roadblocks on the prior year totals. 

Helpful resources

Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 124 members 1,563 guests
Please welcome our newest community members: