Field Format issue

[marial16]

Hallo experts,

i have implemented a Power Automate flow that reads data from an excel files that are uploaded on daily bases on a document Library. The data are copied to a SharePoint List and then i create a BI report based on that.

The excel file has a number of fields String, Dates and Number. However all fields on SharePoint list are Single line of text.

Creating the report, i have noticed an issue regarding the number Columns.

Some are decimal and other whole numbers (that is based on a Unit of Measure Column).

Hence a column named 'Order Quantity' can be either 

UoM	Order Quantity
Kg	5,5
Cargo	1

 The excel file table data are not formated i think.

Some times when a value is 100,5 , in the report it is returned as 1005 

This is causing a problem since i have to make calculations and i am not sure i am getting corrrect values.

Changing the Column format in the BI report does not seem to solve the issue.

Any ideas on that?

[Anonymous]

Hi  @marial16 ,

You can use Format to convert it to the form you want, but it's all text in the end.

Column = FORMAT('Table'[Amount],"#,##0")

https://docs.microsoft.com/en-us/dax/format-function-dax

Best Regards,

Liu Yang

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