Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
I have a dataset with strength descriptors in a column which resembles the following;
Row 1: extremely weak
Row 2: very weak
Row 3: very weak to weak
Row 4: weak
I think I'm relatively happy how to use CONTAINSSTRING() as a custom column in order to identify double word strings like 'very weak' (which should return TRUE for Row 2 and Row 3 for example).
I've also been trying to think of a way to use CONTAINSSTRING() to return TRUE for just the term 'weak' (i.e. False (Row 1), False (Row 2), True (Row 3), True (Row 4)) but I'm struggling to think of the best way to achieve this? I was thinking of filtering out 'very weak' first, but that would mean filtering out Row 3 which also contains the singular 'weak' term.
There might be a simple solution, but my brain is struggling with the logic.
Solved! Go to Solution.
Weird to manipulate strings with DAX given that its biggest strength lies in filtering/aggregation. Do it in Power Query, if possible.
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
89 | |
87 | |
82 | |
64 | |
49 |
User | Count |
---|---|
124 | |
110 | |
88 | |
68 | |
66 |