1.Average of Sales/2.Rolling Average of : last 30 Days / Previous N Months

[Giridhar.Prabhu]

Hi @Venkat.Metadata

You can refer to this article for the computations of this nature. Please note that when you use this approach you are filtering data in the calculated field definition itself and should not filter the visual with the date range.

Period Over Period and Other Date Comparison Calculations (YoY, MoM, YTD, Rolling 90 days, etc)

Hi @lbl You can use the Relative Dates on the parameters (may need to make more parameters) to automatically default to a given date that represents the time period, and can use those in your table headers. It’s not as flexible as being able to write your own calculated logic, but you should be able to get most time periods represented using this (prefix each with ‘Month of’ or ‘Week of’, then put the parameter there… [image] [image]

Regards,
Giri