Forum Discussion

KellyLo's avatar
KellyLo
Frequent Visitor
2 years ago
Solved

Getting MIN Date based on two fiters

Hello - Hoping for some assistance. I have a column named "Source" and there are two values in this column. The table has two date columns, a date for one source and a date for the other. I need a ca...
Need Help
  • kpost's avatar
    kpost
    2 years ago

    Okay so I created this fact table.

     

     

    Based on this fact table, I created this measure:

     

    Min_Date =
    VAR mindate_col1 = MIN([CreatedDate])
    VAR mindate_col2 = MIN([HasAttachmentDate])
    return
    IF(mindate_col1 <= mindate_col2, mindate_col1, mindate_col2)
     
    And was able to produce this visual:
     

     


     

  • KellyLo's avatar
    KellyLo
    2 years ago

    Perfect! This group is so amazing. I have a meeting this afternoon and was a little concerned this wouldn't get solved in time. THANK YOU SO MUCH!!!

     

KellyLo's avatar
KellyLo
Frequent Visitor
2 years ago

Of course - 

  • kpost's avatar
    kpost
    Solution Sage
    2 years ago

    Okay so I created this fact table.

     

     

    Based on this fact table, I created this measure:

     

    Min_Date =
    VAR mindate_col1 = MIN([CreatedDate])
    VAR mindate_col2 = MIN([HasAttachmentDate])
    return
    IF(mindate_col1 <= mindate_col2, mindate_col1, mindate_col2)
     
    And was able to produce this visual:
     

     


     

    • KellyLo's avatar
      KellyLo
      Frequent Visitor
      2 years ago

      Perfect! This group is so amazing. I have a meeting this afternoon and was a little concerned this wouldn't get solved in time. THANK YOU SO MUCH!!!