![]() 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. #PowerQuery – Create a date column from Year number and a month name
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |