Forum Discussion
DAX for Date Filter
Hi, I would appreciate some help to create a DAX formula that lets me pull data for the prior 12 months excluding current month until 12 days into current month (because our finance does not update...
amitchandak
Super User
Super UserAnonymous , try a measure like
Rolling 12 before 1 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],eomonth(MAX('Date'[Date]),-1),-12,MONTH))
Make sure you are using date table
Why Time Intelligence Fails - Powerbi 5 Savior Steps for TI :https://youtu.be/OBf0rjpp5Hw
https://amitchandak.medium.com/power-bi-5-key-points-to-make-time-intelligence-successful-bd52912a5bd4
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Thank you! I will try and let you know.