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 :).

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

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