Forum Discussion

Kasiop's avatar
Kasiop
Helper II
4 years ago
Solved

Substring and Approximative Match

Hi,   I have an issue and I am really stuck here, let me explain it: Currently I have 2 sources and no exact matching.   What do I want to achieve? I want to match SOURCE1.bucket/source w...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    This calculated column formula works

    Column = FIRSTNONBLANK(FILTER(VALUES(Buckets[BUCKET]),SEARCH(Buckets[BUCKET],Data[FULL_DATABASE_NAME],1,0)),1)

AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

I'd probably do this in Power Query:

 

This is the code for the custom column:

(row) =>
    List.Max(
        List.Select(
            SOURCE2[BUCKET],
            each Text.Contains(row[FULL_DATABASE_NAME], _)
        )
    )