Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a column in a table where each element is a Type i.e type number, type text e.t.c.
In GUI when viewing the table I see only text "type" in each cell. In order to see the type I need to "drill down" for each element to see the actual type value.
How can I print out a Type as text? Someting like Type.ToText().. I have spent so much time looking for it and can not find any function doing this. Anyone knows?
Solved! Go to Solution.
Hi @MartinCMQ
My previous reply may be misunderstanding.
If i understand you correctly, please refer to the workarounds below:
https://community.powerbi.com/t5/Power-Query/Power-Query-M-formula-issue-Value-Type/m-p/731232
Or refer to my test below:
Function.Invoke( (_type)=> Table.SingleRow(Table.Schema(#table(type table [Col1 = _type], {})))[TypeName],{[Custom]})
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MartinCMQ
My previous reply may be misunderstanding.
If i understand you correctly, please refer to the workarounds below:
https://community.powerbi.com/t5/Power-Query/Power-Query-M-formula-issue-Value-Type/m-p/731232
Or refer to my test below:
Function.Invoke( (_type)=> Table.SingleRow(Table.Schema(#table(type table [Col1 = _type], {})))[TypeName],{[Custom]})
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @MartinCMQ
If you want to change the data type, please change it as below:
If not, please clear me what you expect.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I'm not sure I understand this, can you post sample data?
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490