Forum Discussion
Helper IVRolling 12 month issue
rogerdea , Make sure to join with Data and Date table in 1-M single direction, The date in the data table should not have a timestamp other than 12 AM
You should date from date table in visual
explained the reasons here 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-bd52912a5bd4Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH))
Rolling Months Formula: https://youtu.be/GS5O4G81fww
Super Userrogerdea , Make sure to join with Data and Date table in 1-M single direction, The date in the data table should not have a timestamp other than 12 AM
You should date from date table in visual
explained the reasons here 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
Rolling 12 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date],MAX('Date'[Date]),-12,MONTH))
Rolling Months Formula: https://youtu.be/GS5O4G81fww