How to calculate date differences in a story within the new model

[former_member776577]

Hi,

I am working with the new model in sac with .csv input files and now I would like to create a measure between a date dimension that is uploaded in the .csv file and the current date.

How is this possible?

As far as I know in the old model there was the option Date difference by creating a measure but this is not the case in the new model?

The measure can be created in the story or in the model, both is fine for me.

[N1kh1l]

tim.graefer

Not sure if I got it right but there is a DATEDIFF() function available in calculated measure option in new model.

Nikhil

[former_member776577]

That solves the first part of my problem, thanks.

The second question would be how it is possible to use the current date (e.g. now () / today ()) as a calculation reference?

[N1kh1l]

tim.graefer,

See if this helps, could not find a function (Today(), now() ) but this allows to select the dates.

[former_member776577]

Yes I know, but the current date is dyanmic. So it should be always the date of the current day and not a fixed one.

[N1kh1l]

tim.graefer,

Unfortunately currently there no functions like TODAY() or NOW() in supported functions but there is a enhancement request which you can upvote below.

Improvement Request Details - Customer Influence (sap.com)

Nikhil