![]() This week I watched the video from Guy in A cube with Patrick and Alex Powers – You thought DAX? Alex shows you Dynamic M-M-Magic! – YouTube. The code has been changed compared to #PowerQuery – Convert a referenced query column to a table without Table.FromList() – Magic trick So I have made a Power Point file with the code included and a small instruction on how to use it. Yesterday I posted an image of some PowerPoint VBA code on LinkedIn and Twitter and a lot of people have asked for a copy of the code. ![]() We have build our own CRM system using a Model driven #PowerBI Convert all Power BI links in Power Point to images Now our commercial managers do not have access to e-conomic but they do need the information about what is invoiced to our customers. In my company we use e-conomic as our ERP system and it is also used to send invoices to our customers. Start by selecting both columns and under the #PowerAutomate – Get a copy of an invoice from your E-conomic system Let’s imagine your data contains two columns with year and the month name and you want to create a date column. ![]() Here is another example that might help you. Sometimes it’s the little things that can help you minimize the number of steps in your Power Queries. Inspired by Darrens Gosbell’s excellent blog post – Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor – Random Procrastination () – and my session at SQLBits 2023 where I showed how to call the chatGPT from within Power Query and how you can use the New chat () #PowerQuery – Create a date column from Year number and a month name Document your #powerbi model with #chatGPT and a #tabulareditor script and browse it in your model ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |