Comma Vs Dot Power Pivot problem

TomexY

New member
Joined
Sep 4, 2020
Messages
1
Reaction score
0
Points
0
Excel Version(s)
2019
Hi,
I have a problem with numbers imported as a text.
In Query designer (Power Pivot) numbers are with comma like this 68011,547889
When Query saved, numbers in final table are with dot. 68011.547889
Querry:
"
WITH MEMBER [Measures].[Kwota1] AS [Measures].[OW-OM], FORMAT_STRING = "#,##"

SELECT NON EMPTY {[Measures].[Kwota1]} ON COLUMNS FROM [FK] CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FONT_NAME, FONT_SIZE, FONT_FLAGS
"
So the problem is that numbers with dot. are treated as Text not number.
Thanks in advance
T
 
Back
Top