The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Morning all,
Struggling a wee bit here to get the DAX to work for me. Looking to use Add Custom Column and utilise Comparer.IgnoreOriginalCase to allow me to create a column which searches into two columns but would need the search to ignore the case sensitivity of the search word as can be words.
Any help greatly appreciated.
Thanks.
Solved! Go to Solution.
Are you using DAX or M? "Comparer.IgnoreOriginalCase" looks like a M parameter, in which case, it's fine, but DAX has options for case sensitive (FIND() function) and insenstivie (SEARCH() function) so there's no need to specify as a parameter.
Are you using DAX or M? "Comparer.IgnoreOriginalCase" looks like a M parameter, in which case, it's fine, but DAX has options for case sensitive (FIND() function) and insenstivie (SEARCH() function) so there's no need to specify as a parameter.
User | Count |
---|---|
27 | |
12 | |
8 | |
8 | |
5 |
User | Count |
---|---|
32 | |
15 | |
12 | |
12 | |
7 |