Forum Discussion
Solved
Extract data from a table iterating from 2 columns
Hi community, I'm requiring your valuable support to build the script to extract data from table "test_lookup" which contains this information: test_id ref_code bench_id result start_dat...
pls try this
_createdate = max('Table'[start_datetime])Measure = rankx(FILTER(all('Table'),'Table'[ref_code]=max('Table'[ref_code])),[_createdate],,DESC)and apply measure to the table visualpls see the attachment below
pls try this
_createdate = max('Table'[start_datetime])
Measure = rankx(FILTER(all('Table'),'Table'[ref_code]=max('Table'[ref_code])),[_createdate],,DESC)
and apply measure to the table visual
pls see the attachment below