Forum Discussion
Solved
Column Containing Values
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 se...
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.
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.