Forum Discussion

datanau001's avatar
datanau001
Icon for Helper III rankHelper III
4 years ago

Power BI Desktop - Help with text search variables

Hello all, I'm working with a report in PBI desktop which is basically used to search text. So, for this search I use as reference an excel file from my sharepoint (D_#TAGS_SPO'[#TAG Unique]) tha...
Need Help
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity Champion
4 years ago

Questions:

Are these measures or columns (Hashtag included 1/2, Combined Hashtags) ?

Can you provide some sample D_ACTIVITY (in text form please)?

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion
    4 years ago

    I had trouble understanding what you are trying to do here.

    I think you want to look through a text value for any items that you have in a predefined list.

    Could you try this power query column please?

    List.Accumulate(#"D_#TAGS_SPO", "", (state, current) => if Text.Contains([MergeSummaryComment], current) then state & " " & current else state)

    D_#TAGS_SPO would need to be a list.  You can create this from a table in Power Query via the interface.