Hello. How do I create a YTD average by month?
2 answers
YTD calculation and to filter out future values of Order date
YEAR([Order Date])=year(today()) AND Month(Order Date) <= Month(today())
use this as filter as set it to True
For each month , calculate AVG of your measure
