Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
exodusme
Frequent Visitor

Column with Text and Decimal Numbers

Hello, I have a column that has both text and numbers in it that is imported from excel. When I bring the column into powerquery it adds a bunch of decimals to it. Not sure what is up. I try to edit it in the excel file and that is fine there, so I don't know what to do.UID Sheet.PNGUID#.PNG

6 REPLIES 6
slorin
Super User
Super User

Hi

Round only if type = number

Table.TransformColumns(Your_Source,{{"Your_Column", each if Value.Type(_) = type number then Number.Round(_,2) else _}})

Stéphane

 

Table.TransformColumns(fact_UID,{{[Unique ID Number], each if Value.Type([Unique ID Number]) = type number then Number.Round([Unique ID Number],2) else [Unique ID Number]}})

 

I am getting "Expression.Error: A cyclic reference was encountered during evaluation"

 

I am guessing I am not using the appropriate formatting for the expression? Not sure where I went wrong though. Thank you for your time.

Table.TransformColumns(fact_UID,{{[Unique ID Number], each if Value.Type(_) = type number then Number.Round(_,2) else _}})

 

Stephane 

 

still getting the cyclical reference =\

Greg_Deckler
Community Champion
Community Champion

@exodusme Maybe try rounding it?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

the column also contains text that i cannot round

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.