Converting certain rows from Feet/inches to Millimeters

[Anonymous]

Hi All,

I am reltively new to Power BI and having problems converting some rows in a table from Imperial measurements to Metric.

To explain I have an SQL Database and it pulls out large ammounts of data from 3D models (Architectural 3D models), there are normally thousands of 3D elements in a file which have varying parameters. for eg Type, Material, New Construction/Demoplished etc Which are all word values, there are yes/no values, some are number values but are not measurements (codes) and others are measurement values; Length, width, offset etc.

I work for an international company and we do projects all over the world so the US projects are in Imperial and other are obvioulsy Metric, but all the data goes into one big list of millions of parameters consisting of the different information above.

Now the original program that we are pulling the data from exports all the measurements in Imperial, (it converts it internally for Metric projects, but Imperial is defualt)

So my question; How do I convert only the Imperial measurements that should be Metric to be able show in the reports as Metric.

Regards

justin

[v-xuding-msft]

Hi @Anonymous ,

I create a sample using DAX formula you can have a try.

I have two tables. And there is a many-to-one relationship between the column of FROM_UNIT and UNIT.

Create a measure.

Total =
    SUMX ( Table2, Table2[AMOUNT] * LASTNONBLANK ( 'Table1'[RATE], "" ) ) & " " & LASTNONBLANK ( 'Table1'[TO_UNIT], "" )

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

I need to convert these columns From Feet to Millimeters