Forum Discussion

Arnoh's avatar
Arnoh
Helper III
3 years ago

finding first record

Hi I have the following issue:   I have a table as below     id source_id   100     101 100   102     103 102   104 101   105 104       I want to find th...
finding first record
iterating
Kev74's avatar
Kev74
Frequent Visitor
3 years ago

Hi try it :

 

first_id = IF(ISBLANK(LOOKUPVALUE('Table'[id], 'Table'[id], 'Table'[source_id])), 'Table'[id], LOOKUPVALUE('Table'[id], 'Table'[id], 'Table'[source_id]))