1 Reply Latest reply on Mar 26, 2020 10:12 AM by Deepak Rai

    Max Date Measure (LOD)

    Patrick Joyce

      Hi Community,

      I'm trying to create a MAX calc in a secondary blend, but I cannot get it to work right.  This is what I attempted first knowing that LOD's don't like blends.

       

      I created a field showing Max Date  first:  MAX(Effective Date)

       

      Then created my calc: IF [Effective Date] = [Date Max] THEN [Change %] END

       

      It didn't like this, so I went with the FIXED calc: {FIXED [Empl ID} : MAX [Effective Date]}.  This solved the previos calc, but now I cant display because of the blend.

       

      I feel like I'm missing something as this should be simple?

       

      Thanks

      Patrick J