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
MirceaAJ
Frequent Visitor

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
Frequent Visitor

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
Frequent Visitor

Up !

UP

Up !

Up !

Up !

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.