Min(Date) in Calculated Dimension?

[dmohanty]

Hi All,

As per the above image I want to do 2nd Column - 3rd Column  to show as a Calculated Dimension.

The logic is the 2nd column should pick the Minimum of the Date value.

How can this be done in a Chart?

[PrashantSangle]

Hi,

In Dimension it is not possible.

Try it in Expression.

and showing difference between two date use Interval()

Regards

[MK_QSL]

=Interval(Aggr(Min([EDI Promise Date])-[Doc Create Date],[Supplier ID]),'DD')

[timanshu]

Hi,

you can do like this in expression to work:

=Interval(vMinDate-[Doc Create Date],'DD')

where vMinDate is variable defined as :  =Min([EDI Promise Date])

Expression gives No of Days that two dates differ.