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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
MirceaAJ
Helper I
Helper I

Find if values are the same for specific groups

Hello all,

 

Beginner here in M so I need your help.

 

My objective is to determine that revisions of files with the same name are consistent. The name of the documents are not known so the list needs to be dinamyc. Also I might have 2 or 3 different types of files with the same name (before the extension). 

 

My data looks similar to this 

 

Document NumberRevision
ABCD.xls

V1

ABCD.doc

V1

ABCD.pwp

V1

BCDE.xls

V2

BCDE.doc

V1

 

The output should be TRUE for ABCD (all revisions are V1), but FALSE for BCDE (V1 is different for V2).

 

Any ideas on how to achieve this ?

8 REPLIES 8
MirceaAJ
Helper I
Helper I

Up !

v-rzhou-msft
Community Support
Community Support

Hi @MirceaAJ ,

 

Please try code as below to create a custom column.

Text.Contains([Document Number],"ABCD")

Result is as below.

vrzhoumsft_0-1696383092412.png

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Hi @v-rzhou-msft @

 

Many thanks for the suggestion. My problem is that I do not know ABCD before hand so I cannot hardcode it in.

 

I need to make further clarification. The XLS, DOC, PWP extensions of the filename ABCD is expected to increase revision together. Imagine it is created from the same file and just exported to different formats. This is why I need to check to confirm if there is no user error at the next upload of documents where a user just forgot to change version.

 

I think I need somehow to split Document number by delimiter (.) and then group ABCD in a separate container (table ?). On each container then check if Revision has the same value. The problem with that is I might have 20+ separate unique containers. Not sure how to manage this 

MirceaAJ
Helper I
Helper I

Up !

UP

Up !

Up !

Up !

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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