need to avoid Start Date is more than End Date seanarios in expression...?

dhasharadh — Sat, 23 Oct 2021 23:17:48 GMT

Hi All,

below is expression of calculated dimension, where as expression is Count(IDs) and Column is End Month.

there is a data issue which is Start Date is Greater than End Date, so am getting this CM - - 1 row in the pivot table.

as it will take much time in changing the ETLs and correct the data issue, now we decided to go ahead with same data, so now i have to edit my condition in such a way that it should avoid those records, so that we can avoid that CM -- 1 row. but my below formula is not helping.

Calculated Dimension :

If(Monthstart(End Date) = Monthstart(Scheduled Date),

(

Round(Interval(Monthstart(End Date) - Monthstart(Start Date),'dd') / 30) <12,

'Current Month - '&Round(Interval(Monthstart(End Date) - Monthstart(Start Date),'dd') / 30),

'Current Month - 12+')

)

, 'Unknown')

Much appreciate your response. @tresB @sunny_talwar @jagan @Anil_Babu_Samineni

Re: need to avoid Start Date is more than End Date seanarios in expression...?

rubenmarin — Sun, 24 Oct 2021 10:30:37 GMT

Hi, if that's your current dimension and it works, I think you only need to enclose that expression in another if that excludes start dates haigher than end dates:

If([Start Date]>[End Date], Null(), [Your current dimension])

topic need to avoid Start Date is more than End Date seanarios in expression...? in App Development

need to avoid Start Date is more than End Date seanarios in expression...?

Re: need to avoid Start Date is more than End Date seanarios in expression...?