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?



      Patrick J