Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |