Forum Discussion
Rolling 12 month based on selection date.
Hi Team,
Could you please help me to get rolling 12 month data based on selection date.
Below DAX used to get the value, but showing blank records.
1 Reply
- amitchandak
Super User
Anonymous , this is correct.
Check there is not timestamp on the date of your table(not date table), and change the data type to datetime, and it should show only 00:00 hour or 12:00 AM
if there is any other time then create a date column
Date = datevalues(Table[DAte column])
make sure Join is single directional
check others
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.
