Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Regards,
kumar
Hi,
Use Addmonths()
like AddMonths(FieldNAme,-1)
Regards
Hi,
In script try AddMonths() like below
LOAD
*,
AddMonths(DateFieldName, -1) AS LastMonthDate
FROM DataSource;
Regards,
Jagan.
if I understand your question is like this (30 days rolling?)
Calculating rolling n-period totals, averages or other aggregations