Calculated Date Dimension

[Anonymous]

I am trying to create a calculated dimension that returns a date in a straight table chart. There is a dimension already called finish date and I would like to calculate a date 60 days prior to that finish date.  Can anyone advise me please?

[oknotsen · Accepted solution]

Hi,

dateField - 60.

Yes, that easy.

You might need to reform the result back to date, so maybe date(dateField - 60).

[ziadm]

I would suggest creating a new data dimension on the load script and do not use the calculated dim for performance issues

Load *,

(finish date - 60) as NewDate

This NewDate is you Dimension

[#4]

date(num(datefield)-60) as newfield

[Anonymous]

That worked, thanks a lot. 

[oknotsen]

Happy I could help.

Please note that from a performance point of view, I would advise to add this value as a field to your data model instead of using a calculated dimension.

Enjoy!