Category: Business

Can you use Power Query Dynamic M Parameters for multi-select?

Posted on by Annie D

Dynamic M parameters in Power Query isn’t anything new. However, Patrick was challenged with using them to allow for multi-select and “select all” with a slicer in a Power BI report. Will he succeed?

Dynamic M query parameters in Power BI Desktop
https://learn.microsoft.com/power-bi/connect-data/desktop-dynamic-m-query-parameters

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— Continue reading “Can you use Power Query Dynamic M Parameters for multi-select?” →

SQL Server in Microsoft Fabric? Use CETaS to move data!

Posted on by Annie D

People have been asking “What about SQL Server?” with regards to Microsoft Fabric. Bob Ward joins us to show a way you can get your SQL data into Fabric with CETaS and the power of shortcuts in OneLake. And, then use that data in Power BI!

CREATE EXTERNAL TABLE AS SELECT (CETAS) (Transact-SQL)
https://learn.microsoft.com/sql/t-sql/statements/create-external-table-as-select-transact-sql?view=sql-server-ver16&tabs=powershell

Microsoft SQL, Data Virtualization and Microsoft Fabric (Slides)
https://aka.ms/sqlfabricdemo

Bob Ward:
https://twitter.com/bobwardms
https://www.linkedin.com/in/bobwardms/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your Continue reading “SQL Server in Microsoft Fabric? Use CETaS to move data!” →

Generate Letters A to Z in Excel #Short Excel Magic Trick 16

Posted on by Annie D

Learn how to generate the letters A to Z with Excel Worksheet Formulas and Power Query.
Download Excel File: https://excelisfun.net/files/SEMT00016.xlsx
#excel #excelisfun #analytics #microsoftexcel #microsoftmvp, #short #shorts #excelmvp #excelformulas #excelfunctions #excelformulaforjobinterview #excelforbegginers #excelshorts #exceltutorial #exceltips #exceltipstricks #freeclass #freecourse #freeclasses #freeexcelcourse #freeexcel #shortsyoutube #shorts #short
#alphabet #text

🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available Continue reading “🔴 Microsoft Fabric/Power BI Q&A – LIVE (June 24, 2023) (Member Chat 2nd Half)” →

Digging into DYNAMIC format strings for DAX Measures in Power BI

Posted on by Annie D

DYNAMIC format strings recently were made available for DAX Measures in Power BI Desktop! Zoe walks us through how you can use these to enhance your reports!

Create dynamic format strings for measures
https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings

Zoe Douglas
https://www.linkedin.com/in/zoedouglas-data/
https://twitter.com/DataZoePowerBI

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— rel=”nofollow”>https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#PowerBI #MicrosoftFabric #GuyInACube

Supercharge Your Power BI Workflow: A Guide to Using ChatGPT

Posted on by Annie D

Join Sam in this enlightening video as he shares his personal journey with OpenAI’s ChatGPT, a revolutionary language model that’s transforming the way we work with Power BI. Discover how the AI is assisting him at every step of his Power BI development journey, from understanding the Power BI interface to handling complex DAX formulas.

In this video, Sam explains how ChatGPT enhances his work by aiding in tasks such as understanding the query editor, aiding with formulas, brainstorming visualization ideas, and even evaluating data. He delves into practical examples, showcasing the immense possibilities that this AI opens up for your Continue reading “Supercharge Your Power BI Workflow: A Guide to Using ChatGPT” →

Two Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365 MECS Class 22

Posted on by Annie D

Download Zipped Folder with All Files: https://excelisfun.net/files/22-M365ExcelClassVideoFiles.zip
Download pdf notes: https://excelisfun.net/files/22-M365ExcelClassDAX.pdf
This video teaches how to create reports when you have two date columns in a Fact Table Three ways: Worksheet Formulas, DAX Data Model Formulas and Power Query. Learn about how to create a Side By Side Report and a Cross Tabulated report for ordered sales and shipped sales. Learn about USERELATIONSHIP DAX Function, and how to create two date dimension tables using Power Query in the Data Model. See solutions in both Power BI Desktop and Excel Power Pivot.
This full free Microsoft 365 Excel Continue reading “Two Date Columns in Fact Table? How To Create Report? DAX, Power Query, Excel? 365 MECS Class 22” →

Get the most as a Data Scientist with Microsoft Fabric (Public Preview)

Posted on by Annie D

Going down the DATA SCIENCE path can be hard when trying to get all the right data. Microsoft Fabric breaks down barriers and allows for easy reuse of data with OneLake. Nellie joins to talk about how data scientists can take advantage!

What is Data Science in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-science/data-science-overview

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook?toc=%2Ffabric%2Fdata-science%2Ftoc.json&bc=%2Ffabric%2Fdata-science%2Fbreadcrumb%2Ftoc.json

How to accelerate data prep with Data Wrangler in Microsoft Fabric
https://learn.microsoft.com/fabric/data-science/data-wrangler

Nellie Gustafsson
https://twitter.com/nelliegson
https://www.linkedin.com/in/nelliegustafsson/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have Continue reading “Get the most as a Data Scientist with Microsoft Fabric (Public Preview)” →

Adding Last Refresh Date and Time to Power BI Reporting

Posted on by Bb

A frequent question I have received is “How do I add the last refresh date and time to Power BI reporting?”. Great news, this solution is very simple! The code I provide in this article will allow you to create a source, and then use this in one or more of your visuals so that it’s always clear to you and your end users when the report was last refreshed.

Note: if you need refresh times for your individual sources, one solution would be to add a column with DateTime.LocalNow() and then work a DAX measure off of that once the data from that source is loaded for the first time. Definitely comment below if you would like me to expand on that.

Adding the Refresh Source

You are simply going to add a new source, choose Blank from the menu.

Click Advanced Editor to open up the M code window, then copy in the code below.

Power Query Code (M) – Power BI Last Refresh Date and Time

Power Query Last Refresh Date and Time, Power Query M, Power BI Last Refresh Date and Time
Last Refresh Date and Time in Power BI M Language

Click Done. You will notice that I have added the word “Updated” ahead of the date and time in this code. I prefer to display the measure this way in my reporting. If you would prefer to just have the date and time, simply delete the steps after Source in the Query Settings at the right. I find it’s best to work from the bottom, up when removing steps.

Of course, you can also edit the output as you see fit, displaying in the way that works best for your report.

Power Query Last Refresh Date and Time, Power Query M, Power BI Last Refresh Date and Time
Power Query Settings and Steps

Adding the Last Refresh Date and Time to the Report

After Applying the change, you should now see the source and column listed.

Last Update

I find it easiest to add a card visual to display the date and time. Simply select the card visual and then select the LastUpdate column. You can then edit the visual as you see fit for your report.

Card Visual

Final Output

Last Refresh Date and Time Visual in Power BI

As always, I hope this post has helped you out. Please subscribe to be notified of the latest posts and leave a comment if you have any topics you’d like to see covered here. Thanks!

Topics covered in this post: Power Query Last Refresh Date and Time, Power Query M Current Date and Time, Last Refresh Date and Time in Power BI

Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)

Posted on by Annie D

You’ve got your data into OneLake and a Lakehouse, but now what? What can you do with that data after you’ve landed it in Microsoft Fabric? Justyna walks us through different areas where you can leverage your data throughout fabric. From data warehouses to even Power BI!

What is Data engineering in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/data-engineering-overview

What is Spark compute in Microsoft Fabric?
https://learn.microsoft.com/fabric/data-engineering/spark-compute

Develop, execute, and manage Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/author-execute-notebook

OneLake shortcuts
https://learn.microsoft.com/fabric/onelake/onelake-shortcuts

Justyna Lucznik
https://twitter.com/JustynaLucznik
https://www.linkedin.com/in/justyna-lucznik/

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to Continue reading “Your data is in the Lakehouse, but now what? | Microsoft Fabric (Public Preview)” →

Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/21-M365ExcelClass.xlsx
Pdf notes: https://excelisfun.net/files/21-M365ExcelClass.pdf
Learn how to build Mortgage Loan Schedule to break out interest and principal reduction from a loan payment. Theis same schedule works on Corporate Bonds to help record Interest on Income Statement6 and Principal Reduction on Balance Sheet.

This full free Microsoft 365 Excel & Power BI class is taught by Excel MVP and Highline College Professor and can be found here: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
This video covers.
1. (00:00) Introduction and video topics
2. (00:30) Build Mortgage Loan Schedule to break out interest and principal reduction from a loan payment using Continue reading “Build Mortgage Home Loan Schedule. Traditional &Dynamic Spilled Array Formulas. 365 MECS Class 21” →

Excel For The Infection Preventionist – Preview of APIC Pre-Conference

Posted on by Annie D

The Association for Professionals in Infection Control and Epidemiology is holding their annual conference in Orlando June 26-28, 2023. I will be presenting a half-day pre-conference session on Sunday June 25, 2023 from 8 AM to 1 PM.

My goal in the session is to make you more comfortable with Microsoft Excel. In this preview, I download data from the CDC, do some simple clean-up. I use a few Excel formulas to add some useful metrics. I then display the results on a Map in Microsoft Excel.

Everyone who attends my session receives a copy of my book, MrExcel 2021 – Unmasking Continue reading “Excel For The Infection Preventionist – Preview of APIC Pre-Conference” →