Forum Discussion
Rolling 3 months Average
Hi everyone. I have encounter an issue on my report and need your help. I need a calculation of Trend and it's definition is: Average of the last 3 months of the month selected. If my slice...
Hi ERD
Your usage of the time-intel functions is incorrect and will often yield wrong values. Please refer to this guide to understand when you can correctly use them: DATESINPERIOD – DAX Guide. A hint would be: You cannot use time-intel functions with fact tables. You have to have a proper date/calendar table (dimension) to be safe.
ERD
Community Champion
Community ChampionThanks for the hint! Edited previous advise.