Forum Discussion

UBComma's avatar
UBComma
Icon for Helper III rankHelper III
3 years ago
Solved

Create new records from keyword list

AlexisOlson or BA_Pete   Any chance you would have a thought on this? I am trying to add a new column and new records to a table based on whether a list of keywords exists in the 'Title cleaned' col...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    3 years ago

    You can link to a cloud file using e.g. Dropbox/Google Drive/SharePoint/OneDrive. Make sure the file doesn't contain any sensitive data before you make it public.

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
3 years ago

IN Dax Table

 

Table =
GENERATE (
    src,
    VAR str = src[Title cleaned]
    RETURN
        SELECTCOLUMNS (
            FILTER ( Keywords, CONTAINSSTRING ( str, Keywords[Column1] ) ),
            "val", Keywords[Column1]
        )
)

 

in DAX MEasure

Measure = 
CONCATENATEX (
    GENERATE (
        src,
        VAR str = src[Title cleaned]
        RETURN
            SELECTCOLUMNS (
                FILTER ( Keywords, CONTAINSSTRING ( str, Keywords[Column1] ) ),
                "val", Keywords[Column1]
            )
    ),
    [val],
    ",",
    [val], ASC
)

 

 

UBComma's avatar
UBComma
Icon for Helper III rankHelper III
3 years ago

Thank you, I am looking for a Power Query solution