Forum Discussion
product
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.
3 Replies
- Nathaniel_C
Community Champion
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:
Function Description 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.
NathanielI 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
- Nathaniel_C
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
