I have a date field and i have some measures.
My requirement is like, 1month needs to be deducted subsequently from date field and data should roll up for each one month.
Can anyone help me how to deduct one month from date field.
See the Attached Link.
Subtract 1 month from Date Variable in set analysis
Hope this helps
In script try AddMonths() like below
AddMonths(DateFieldName, -1) AS LastMonthDate
if I understand your question is like this (30 days rolling?)
Calculating rolling n-period totals, averages or other aggregations
Retrieving data ...