Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
p2 | c2 | 20 |
p3 | c3 | 30 |
P1 | c4 | 40 |
p2 | c5 | 50 |
p3 | c6 | 60 |
p4 | c7 | 70 |
How can I achieve this?
Solved! Go to Solution.
@ppatil , 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])))
@ppatil , 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])))
Hello @ppatil ,
Do we have date/time field in data?
How to identify which record is first?
Thanks.
Shishir
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |