Forum Discussion

RamenAnalytics's avatar
RamenAnalytics
New Member
1 year ago
Solved

Trying to manage OS versions (cannot convert to Numbers)

Hello all, I am trying to manage iOS versions within PowerBI - These numbers have two decimals within them "17.5.0" i believe this fact is causing some discrepancies when attempting to convert the...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi RamenAnalytics ,

     

    Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

    I reviewed it and I tried to reproduce it. I found that in excel, like "17.5.0" could be set up as number type.

    I think you want to do the same as in Power BI Desktop, right?

    However, you can't do this way in Desktop as it is by default.

    After testing, the text format "xx.x.x" can also be compared in size. As follows, the results of comparing the size are normal. I added a custom column that returns 1 if [device_os_version] is larger than [device_os_version2], otherwise it returns 0.

    Hope this helps.

     

    Best Regards,

    Stephen Tao

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RamenAnalytics ,

 

Pls has your problem been solved? If so, accept the reply as a solution. This will make it easier for the future people to find the answer quickly.

I reviewed it and I tried to reproduce it. I found that in excel, like "17.5.0" could be set up as number type.

I think you want to do the same as in Power BI Desktop, right?

However, you can't do this way in Desktop as it is by default.

After testing, the text format "xx.x.x" can also be compared in size. As follows, the results of comparing the size are normal. I added a custom column that returns 1 if [device_os_version] is larger than [device_os_version2], otherwise it returns 0.

Hope this helps.

 

Best Regards,

Stephen Tao