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   Thank...
Need Help
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