Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have an Azure SQL file that lists mobile devices. One field is the DeviceOS, which is formated as follows:
Android 8.0.0
iOS 12.4.0
Android 7.1.2
and so on.
I created a new column with the following DAX formula:
Solved! Go to Solution.
Hi @bschmiedeler,
My suggestion is:
1) Using PowerQuery;
2) Split column "DeviceOS" by Delimeter;
3) Select "Space" as delimiter;
4) Split at Right-most delimiter;
5) Change the second column type, from "Int64.Type" to "type text"
From:
To:
Hi @bschmiedeler,
My suggestion is:
1) Using PowerQuery;
2) Split column "DeviceOS" by Delimeter;
3) Select "Space" as delimiter;
4) Split at Right-most delimiter;
5) Change the second column type, from "Int64.Type" to "type text"
From:
To: