PB_MZRegular Visitor3 years agoTrailing 6 months average Hi, I would like to calculate the trailing 6 month average for Margin % (A), Margin % (B), Margin % (C). They are measures instead of columns. I tried several ways but none of them worked for...Show More
PB_MZRegular Visitor to FreemanZ3 years agoHi,Sorry for the late resposne. Trailing 6 months average means I need to calculate the average of (previous 5 months + current month) for each month.
PB_MZRegular Visitor to FreemanZ3 years agoHi,Sorry for the late resposne. Trailing 6 months average means I need to calculate the average of (previous 5 months + current month) for each month.
Related content12 months trailing measureTrailing Month SlicerRemove trailing commasCalculating average 12 month averageTotal per month / average per month
