How do I create a custom column that grabs the ip from a description?

Question

I'm trying to make a simple dashboard to review our logs and was hoping I could create custom column that grabs IP addresses from the description but I am having a rough time when there is no IP or if its not in between two lines.

Is there a way for powerbi to look for #.#.#.# which is typically an IP address and display it in a column and not show anything if there isn't an IP #.#.#.# in the description?

v-luwang-msft · Accepted Answer

Hi&nbsp;bashheadonwall&nbsp;,
Use the following dax to create a new column:
&nbsp;
Column = 
VAR test1 =
    MID ( 'Table'[Description], SEARCH ( ":", 'Table'[Description],, 0 ) + 1, 1 )
VAR test2 =
    SEARCH (
        ",",
        'Table'[Description],
        SEARCH ( ":", 'Table'[Description],, 0 ) + 1,
        0
    )
VAR test3 =
    IF (
        test1 = "1"
            || test1 = "2"
            || test1 = "3"
            || test1 = "4"
            || test1 = "5"
            || test1 = "6"
            || test1 = "7"
            || test1 = "8"
            || test1 = "9"
            || test1 = "0",
        MID (
            'Table'[Description],
            SEARCH ( ":", 'Table'[Description],, 0 ) + 1,
            test2
                - ( SEARCH ( ":", 'Table'[Description],, 0 ) + 1 )
        )
    )
RETURN
    test3

&nbsp;
&nbsp;
return:

&nbsp;
&nbsp;
Did I answer your question? Mark my post as a solution!
Best Regards
Lucien

Forum Discussion

How do I create a custom column that grabs the ip from a description?

2 Replies

Related content

How creating a Python custom library

Creating a custom column

create custom column concatenated

Creating Custom columns

Creating a custom leaderboard