Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a column of product versions (example: 2.3.5 and 2.3.4) I need to be able to query that column and return a true/false. The true's need to be 2.3.5 and the false's 2.3.4. I need this to be on going, so when the product version changes to 2.3.6 those are now true and the 2.3.5 are false's. I think I need to use the MAX function but I'm having a hard time with the dots in the versions. any help would be appreciated.
Hi @JoeHoover ,
In PBI you can add a column as shown below, although it might be better to do it in PQ in which case make a conditional column with:
Text.End | Returns the number of characters from the end of a text value. |
Of course you will have to update it as the version changes.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
I need to have a solution that doens't require updating a table everytime a new version comes out.
example: (I need to be able to use DAX to only report the non highest version. ex. 3.4.9.8 and 3.4.9.1)
Version:
3.5.6.7
3.5.6.7
3.4.9.8
3.4.9.1
In Power Query, create second column, making sure that the ver is txt, use the find and replace. "." and leave replace with blank.
Then you should be able to use MAX() Once this is in your query you won't have to change when new version comes out.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |