Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ppatil
Helper III
Helper III

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 

p2 

c2 

20 

p3 

c3 

30 

P1 

c4 

40 

p2 

c5 

50 

p3 

c6 

60 

p4 

c7 

70 

 

How can I achieve this?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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])))

View solution in original post

4 REPLIES 4
amitchandak
Super User
Super User

@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])))

Thank U @amitchandak 

Shishir22
Solution Sage
Solution Sage

Hello @ppatil ,

 

Do we have date/time field in data?

How to identify which record is first?

 

Thanks.

Shishir

Cheers,
Shishir

Hello @Shishir22 
No such column to identify which is the first record.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.