Forum Discussion
Helper IMass Data Editing Query/Data Modelling
Hi ImkeF,
Thanks for your link imkeF.
>>However, this will convert all columns that come in as text to a number format (and throw errors where this is not possible).
The comment of the function: GetStruct(table, choosed column name list, convert type list)
The second parameter is the filtered list. The formula will check it first. The last paramter support mutiple type, for example:
{{type date, type text},{type text, type number},...}
BTW, I try to manual write one because I haven't found the related information yet.:smileyhappy:
Regards,
Xiaoxin Sheng
Helper IHi Anonymous and ImkeF,
Sorry but I am very new to this whole thing.
If I understand your proposed solution correctly, this is a formula which I use within my report which will adjust the formatting on the desired columns?
This sounds great - one thing (and don't laugh) where do I put that formula?
Many thanks.
Hi dcadwallader,
>>This sounds great - one thing (and don't laugh) where do I put that formula?
These are power query formulas, you can open the query editor and find out the queries, open the advanced editor panel to modify them.
Regards,
Xiaoxin Sheng