Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
mannyjha7860
New Member

Rolling 12 months excluding current month

I ve tried rolling 12 month dax in the visual but when I select 12 months it doesn't show me full data for last year 1st month(Aug).But when I select 13 months it show me the full data for (Aug).

Dax I used:-

Rolling 12 Months = var daydiff=DATEDIFF('Calendar'[Date],TODAY(),MONTH ) return
IF(daydiff>=0 && daydiff<=11,"last 12 months","not last 12 months")

WhatsApp Image 2021-08-13 at 15.29.27.jpegWhatsApp Image 2021-08-13 at 15.29.46.jpeg

1 REPLY 1
amitchandak
Super User
Super User

@mannyjha7860 , datediff in case of current month is 0, if you need last 12 month excluding current, then it should be

 

Rolling 12 Months = var daydiff=DATEDIFF('Calendar'[Date],TODAY(),MONTH ) return
IF(daydiff>0 && daydiff<=12,"last 12 months","not last 12 months")

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.