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


How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 252 members 2,716 guests
Please welcome our newest community members: