Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
In Dimension it is not possible.
Try it in Expression.
and showing difference between two date use Interval()
Regards
=Interval(Aggr(Min([EDI Promise Date])-[Doc Create Date],[Supplier ID]),'DD')
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.