topic Re: product in DAX Commands and Tips

product

JoeHoover — Fri, 20 Sep 2019 19:01:39 GMT

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.

Re: product

Nathaniel_C — Fri, 20 Sep 2019 22:55:57 GMT

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.
Nathaniel

Re: product

JoeHoover — Thu, 26 Sep 2019 14:20:49 GMT

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.4.9.8

3.4.9.1

Re: product

Nathaniel_C — Thu, 26 Sep 2019 17:43:06 GMT

JoeHoover ,

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