Forum Discussion
Rolling average
Hello!! Community. Iam facing problem in one visual table i'll need your help. There are 3 columns in the table Sheets1; The columns are Sales Date, Total Sales, Region. I want to calculate 3 month ...
tsurugi824 share the measure definition, and also make sure date-related columns are used from the date dimension.
parry2k This is the measure and screenshot attached below:
Rolling avgg = CALCULATE(average(Sales[total sales]), DATESINPERIOD('Calendar'[Date], MAX('Calendar'[Date]), -3, MONTH))
