Forum Discussion
First occurrence value display in table visual
Hi Community..!! I need to create a table visual which consist of 1st occurrence of each product. Please refer the below sample data. Product category price P1 c1 10 ...
Anonymous , Try a measure like the one below with the above fields. Add an index column in the power query first
calculate(max(Table[Price]), filter(Table, Table[Index] = minx(filter(allselected(Table), Table[Product] = max(Table[Product])), Table[Index])))
