Blog Post

Power BI Community Blog
2 MIN READ

Power BI: Working with Non-Standard Time Periods

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago
In my last article, I discussed how we can compare two date ranges. This time, we talk about non-standard periods.   Comparing a month to the last month or year to last year has been made easy by...
Updated 6 years ago
Version 2.0
Time Intelligence
Working with Non Standatd Periods
amitchandak's avatar
Icon for Super User rankSuper User
Joined June 27, 2019
View Profile
Power BI Community Blog
On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news. If you are interested in becoming a community blog author, send a private message to Natalie_iTalent. An overview of the community blogs can be found here.
Anonymous's avatar
Anonymous
Not applicable
4 years ago

amitchandak spandy34 
I am using non standard date table and my date table  is below with the start date and end date of each period.
So i wanted to calculate MTD, MTD LY YTD, YTD LY, Yesterday, Yesterday LY, Today, Today LY.
Time intelligence functions are not working here. So confused a lot and stucked, Please i need help.