Forum Discussion
product
Community ChampionHi 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
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
- 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
