You can perform a type conversion within an Add.Column statement without having to do a second step after.
Looks like this :
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
View solution in original post
@ImkeF - and here i was congratulating myself on not writing bloated code ! Thanks for the explanation !
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!