Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
You can perform a type conversion within an Add.Column statement without having to do a second step after.
Looks like this :
Solved! Go to Solution.
Hi @frano72 ,
my friend Lars Schreiber has a good explanation why this happens and how to avoid here: Ascribed types in M: why to generally avoid them (ssbi-blog.de)
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
@ImkeF - and here i was congratulating myself on not writing bloated code ! Thanks for the explanation !
Hi @frano72 ,
my friend Lars Schreiber has a good explanation why this happens and how to avoid here: Ascribed types in M: why to generally avoid them (ssbi-blog.de)
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries