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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
agne0211
New Member

How to find specific point in text

Hi,

 

I have many different version numbers and I need to find in which position are points that are in red color: "2.5.90.0",  "2.10.11.12"

To be more specific, I need to create measure which would count position of last point in those version numbers.

 

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@agne0211 

You can add a custom column in Power Query as follows:

=Text.PositionOf([Text],".", Occurrence.Last) + 1

Fowmy_0-1611327003316.png

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@agne0211 

You can add a custom column in Power Query as follows:

=Text.PositionOf([Text],".", Occurrence.Last) + 1

Fowmy_0-1611327003316.png

 

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.