Changes in Start Date and End Date

[#1]

Hi Experts,

I have number of projects with start date and end date. But some of the projects has changed in either Start date or End date. Now I want to show 1. Changed in Start Date 2. Changed in End Date 3. Changed in both Start Date and End Date 4. Single time Shifted 5. Multiple times shifted. How to achieve this?

Please find attached sample file

Thanks in Advance

[sunny_talwar]

Not sure I understand the requirement completely. Would you be able to provide desired output for the provided sample?

[MarcoWedel]

Hi,

maybe like this?

hope this helps

regards

Marco

[jagan]

HI,

Try like this

1. Changed in Start Date

Sum(Aggr(If(Count(Distinct [Start Date]) > 1, 1, 0), [Proj ID]))

2. Changed in End Date

Sum(Aggr(If(Count(Distinct [End Date]) > 1, 1, 0), [Proj ID]))

3. Changed in both Start Date and End Date

If(Sum(Aggr(If(Count(Distinct [Start Date]) > 1 AND If(Count(Distinct [End Date]) > 1, 1, 0), [Proj ID]))

4. Single time Shifted

If(Sum(Aggr(If(Count(Distinct [Start Date]) = 2 OR If(Count(Distinct [End Date]) = 2, 1, 0), [Proj ID]))

5. Multiple times shifted.

If(Sum(Aggr(If(Count(Distinct [Start Date]) > 2 OR If(Count(Distinct [End Date]) > 2, 1, 0), [Proj ID]))

Hope this helps you.

Regards,

Jagan.