Forum Discussion
Combing TREATAS, COTAINSSTRING and CONCATENATEX issue (Icon Map)
Hi all, I have quite a bespoke issue that I can seem to find a resolution for (either by my own working or by searching online). I have a column of data in one table that has a corresponding strings...
daXtreme
Solution Sage
Solution SagePower BI is a tool that works extremely well with denormalized data only, think: star schema. Each column should contain atomic data, not compounds like your comma-delimited values. Please denormalize the table using Power Query, create suitable columns for grouping and... your life (and your users') will be much, much easier. No more containsstring, concatenatex and similar BS. Your DAX will also become as easy as 1-2-3. Not to even mention it'll be fast.