Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I'm trying to create something that will get me let's say #TopPlan in a column that contains multiple other values. For example
The first column is where all the values are and the second column is a measure I created using dax contains and I wanted anything that says #TopPlan but as you can see it only shows true when it is just only #TopPlan is in it
Any idea I can get the rest of #TopPlan with other values as well?
Thanks
Solved! Go to Solution.
Hi @powerbiwork
Download PBIX file with these examples.
In Power Query you can add a Custom Column
Table.AddColumn(Source, "Custom", each if Text.Contains([TextCol], "#TopPlan") then true else false)
Or in DAX create a Calculated Column
Column = IF(SEARCH("#TopPlan", 'TextTable'[TextCol],,0)>0, True , False)
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Thanks so much!
Hi @powerbiwork
Download PBIX file with these examples.
In Power Query you can add a Custom Column
Table.AddColumn(Source, "Custom", each if Text.Contains([TextCol], "#TopPlan") then true else false)
Or in DAX create a Calculated Column
Column = IF(SEARCH("#TopPlan", 'TextTable'[TextCol],,0)>0, True , False)
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Proud to be a Super User!
Hi,
I suggest you use the SEARCH() function as a calculated column. Please read more here - SEARCH function (DAX) - DAX | Microsoft Docs
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |