Forum Discussion

atifbutt's avatar
atifbutt
Frequent Visitor
8 years ago
Solved

If condition with max date

Hi,   I'm building dashboard in Direct Query mode.   Data = Asatdate, UserID, Name, Ethnicity   I'd like to create a oclumn "Ethnicity Type" and to put values from Ethnicity column if the UserI...
Need Help
  • atifbutt's avatar
    atifbutt
    8 years ago

    Thanks for replying Xiaoxin. I've found the solution via sql query :).

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi atifbutt,

 

Please share some sample data for test and coding formula.

 

Regards,

Xiaoxin Sheng

atifbutt's avatar
atifbutt
Frequent Visitor
8 years ago

Thanks for replying Xiaoxin. I've found the solution via sql query :).

  • Stuznet's avatar
    Stuznet
    Helper V
    8 years ago

    Could you kindly post the SQL solution?

     

    Thanks

    • atifbutt's avatar
      atifbutt
      Frequent Visitor
      8 years ago

      Select field1,field2,field3
      from (select field1,field2, field3,
      row_number() over (partition by employeenumber order by (datefield "to pick the latest record") desc) as rn from tablename) as T
      Where RN = 1

    • atifbutt's avatar
      atifbutt
      Frequent Visitor
      8 years ago

      Select field1,field2,field3
      from (select field1,field2, field3,
      row_number() over (partition by employeenumber order by (datefield "to pick the latest record") desc) as rn from tablename) as T
      Where RN = 1

      • Stuznet's avatar
        Stuznet
        Helper V
        8 years ago
        Thank you so much