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)

Kasiop's avatar
Kasiop
Helper II
4 years ago

Sorry HotChilli , but I am using dummy data, in reallity I dont have any number on the middle.