7/3/2023 0 Comments Tabular editor translations![]() ![]() 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 () – to describe your M code. #PowerQuery – Filter a table based on another table column or list – and some Filter aha’s.#PowerQuery – Control the expand columns so it includes new columns.#PowerQuery - Replicate doing an Excel VLOOKUP in M.Set size for multiple visualizations in #PowerBI at the same time.#PowerQuery – Create a date column from Year number and a month name.We have build our own CRM system using a Model driven 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 My first choice was to use a shape Document your #powerbi model with #chatGPT and a #tabulareditor script and browse it in your model Yesterday I worked on a Power BI report where the client wanted to add vertical bar next to the slicer in order to make the design of the slicers a little bit nicer and also to make the slicers recognizable cross pages by using the same coloring. So I use the excellent theme designer tool from powerbi.tips – And I use the paid version so I #PowerBI – Adding a vertical bar to your slicer I am a big fan of using themes in Power BI but the current theme designer in Power BI desktop is very limited and doesn’t support all the things you really can do with themes. How to try/test another #PowerBI theme on your existing reports in the service ![]()
0 Comments
Leave a Reply. |