Forum Discussion

exodusme's avatar
exodusme
Frequent Visitor
3 years ago

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 ...
Need Help
exodusme's avatar
exodusme
Frequent Visitor
3 years ago

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.

slorin's avatar
slorin
Super User
3 years ago

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

 

Stephane 

 

  • exodusme's avatar
    exodusme
    Frequent Visitor
    3 years ago

    still getting the cyclical reference =\