cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alepage Member
Member

how to get ith value in a field

Hello,

 

Imagine that I have a table Named Table1.  Table1 may contains few different fields, let's say Field1, Field2, ..., Field10.

 

If for Example, Field3 contains the following values

a

b

c

d

e

f

g

 

How can I select 4th value which is equal to e?

 

Thanks in advance for your help

alepage

3 REPLIES 3
Super User III
Super User III

Re: how to get ith value in a field

@alepage What is the context of the calculation you are trying to accomplish? Do you need to filter the row down to only that value? Do you need only that value to be compared to something else? Do you need that value as a starting point?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
alepage Member
Member

Re: how to get ith value in a field

What I need this value as starting point.  I may need another value (next field) as an ending point

Community Support Team
Community Support Team

Re: how to get ith value in a field

Hi @alepage ,

I have a little confused about your scenario.

If it is covenient, could you show your sample data in text-tabular format in addition to or screen captures. That allows people trying to help to readily copy the data and run a quick test, plus it increases the likelihood of your question being answered. Just use 'Copy table' in Power BI and paste it here.

I also would appreciate it if you could share your desired output so that we could understand your logic better.

Best  Regards,

Cherry

 

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

January 2020 Community Highlights

January 2020 Community Highlights

Make sure you didn't miss any of the things that happened in the community in January!

Top Solution Authors