Forum Discussion
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...
Hi,
This calculated column formula works
Column = FIRSTNONBLANK(FILTER(VALUES(Buckets[BUCKET]),SEARCH(Buckets[BUCKET],Data[FULL_DATABASE_NAME],1,0)),1)
Sorry HotChilli , but I am using dummy data, in reallity I dont have any number on the middle.