Forum Discussion
Solved
Returning column value if other column is unique using power query
Hi everyone, Below is an example of the table I am working with.. ID Number Passes Fails 123456 40 3 123456 40 ...
Do you want to identify the first occurrence of each ID number and return the value from the passes column? In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
SQL
select *,iif(row_number() over ( partition by f01)=1,f02,0) column from fill_first_of_section order by rowid;