Number from text RRS feed

  • Question

  • Hi

    Just look first at the SIZE column from the below screenshot. 

    It is a text column. Currently this is the only one existing column in my data table.

    Other columns "PROPER SIZE" and "SIZE RANGE" are the ones I am going to add to my data model.

    How to do "PROPER SIZE" calculated column, based on which I would be able to create "SIZE RANGE"?

    The shown example is a part of huge data base with thousands of rows.

    I expect "PROPER SIZE" to be a number data type to be able to create ranges in "SIZE RANGE".

    I tried with:

    1) ISNUMBER - but for all text values in SIZE it always gives FALSE

    2) VALUES - but it is not working with text values

    If not in DAX, optionaly in Power Query

    Any ideas?

    Tuesday, March 1, 2016 10:53 AM


All replies