Excel Forum

DataFormat error : We couldn't convert et number in Power Query

Stanley Saint Louis

New Member

Members

Forum Posts: 1

Member Since:
March 16, 2022

Offline

March 16, 2022 - 2:32 pm

I have data in numbers (with commas and a point and two decimals after the point) Excel that I imported on PQ. Once my data is on power query, they are in "any" format. When I try to put them in "currency" format, it displays an error message: "we couldn't convert to number".

Can someone please help me. I've been at this for a while.

Attachments

Screenshot-2022-03-16-002850.png (10 KB)

Riny van Eekelen

Örnsköldsvik, Sweden

Moderator

Members

Trusted Members

Moderators

Power BI

Forum Posts: 605

Member Since:
January 31, 2022

Offline

March 16, 2022 - 4:30 pm

When you change the data type don't choose "Currency" directly. The format that the amounts come in is probably not the same as what you have have in local system settings. Change the data type by "Using locale" and then Currency and specify a format that matches the data source. Probably "English US" will work as that uses comma's as thousand-separators and decimal points.

Top Posters:

SunnyKow: 1432

Anders Sehlstedt: 880

Purfleet: 414

Frans Visser: 346

David_Ng: 306

lea cohen: 237

Jessica Stewart: 219

A.Maurizio: 213

Aye Mu: 201

jaryszek: 183

Newest Members:

Lisa Myers

David von Kleek

Ronald White

Ginette Guevremont

Taryn Ambrosi

Mark Davenport

Christy Nichols

Harald Endres

Ashley Hughes

Herbie Key

Forum Stats:

Groups: 3

Forums: 24

Topics: 6528

Posts: 28594

Member Stats:

Guest Posters: 49

Members: 32818

Moderators: 2

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: Velouria, Riny van Eekelen

DataFormat error : We couldn't convert et number in Power Query|Power Query|Excel Forum|My Online Training Hub