How to Transform an IP to MD5 Hash

[SandyBL]

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

[v-yuezhe-msft]

@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