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)

HotChilli's avatar
HotChilli
Community Champion
4 years ago

What about using Text.Range with Text.Length from the Source column to get the bucket from the last column?

Post some more realistic data (not a picture) if you want more help, please.