Forum Discussion

Shruthi96's avatar
Shruthi96
Icon for Helper III rankHelper III
3 years ago
Solved

get maximum date from row category

Hi Folks, 

 

I am looking for a solution to categorize the row as 1 or 0 in column scope, based on maximum end date and Include column  "Yes" . Below is the snap shot i have attached.  Can you help me with formula. Many thanks

 

 

Need Help
  • Shruthi96's avatar
    Shruthi96
    3 years ago

    Thanks Jihwan_Kim , I applied filter for include. It worked

     

    Scope CC =
    IF (
        MAXX (
            FILTER ( Data, Data[Include] = "Yes" && Data[Product] = EARLIER ( Data[Product] ) ),
            Data[End Date]
        ) = Data[End Date],
        1,
        0
    )

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    3 years ago

    Hi,

    Please check the below picture and the attached pbix file.

     

     

     

    Scope CC =
IF (
    MAXX (
        FILTER ( Data, Data[Product] = EARLIER ( Data[Product] ) ),
        Data[End Date]
    ) = Data[End Date],
    1,
    0
)
    • Shruthi96's avatar
      Shruthi96
      Icon for Helper III rankHelper III
      3 years ago

      Thanks Jihwan_Kim , I applied filter for include. It worked

       

      Scope CC =
      IF (
          MAXX (
              FILTER ( Data, Data[Include] = "Yes" && Data[Product] = EARLIER ( Data[Product] ) ),
              Data[End Date]
          ) = Data[End Date],
          1,
          0
      )