Forum Discussion

SandyBL's avatar
SandyBL
Icon for Advocate II rankAdvocate II
9 years ago

How to Transform an IP to MD5 Hash

Hey guys I want to md5 hash IP addresses I have in a database 

 

Column1: IP address

New Column 2: MD5 Hash IP address

 

I've done this in sql but can't find the DAX version to do that

 

Thanks

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    SandyBL,

    According to my knowledge, no DAX functions could be used to hash string directly. In your scenario, you can write T-SQL to hash your columns when you import data from SQL database to Power BI Desktop.


    Regards,
    Lydia