Calculating Averages Per Weekdays or Weekends Using DAX In Power BI [2023 Update]

The AVERAGEX function in DAX is used to calculate the average of a set of numeric values in a table or expression that results in a table. It is useful in Power BI reports when you need to calculate an average for a group of values based on a specific condition, such as average sales per customer.

To maximize the function, use it with a filtered table or expression, consider using it with other DAX functions, and be mindful of performance with large data sets. This also showcases how adaptable iterating formulas are in DAX. In this video, Sam Continue reading “Calculating Averages Per Weekdays or Weekends Using DAX In Power BI [2023 Update]”

Setup a Reverse Hybrid Table without using Tabular Editor for Power BI!

Hybrid Tables can be very useful for mixing archived data with current data. Pat Mahoney joins Patrick to show how to configure a Hybrid Table within a Power BI dataset without using Tabular Editor. Just some straight “M”agic.

Hybrid Table Documentation:
https://learn.microsoft.com/power-bi/connect-data/service-dataset-modes-understand#hybrid-tables

Connect with Pat Mahoney:
https://twitter.com/mahoneypa
https://www.linkedin.com/in/patrick-mahoney-3138526/
https://www.youtube.com/@hoosierbi5669
https://hoosierbi.com/

📢 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!
*******************

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

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

#PowerBI #HybridTable #GuyInACube

How To Create A Word Cloud Of Any Shape In Power BI Using Python

It’s a handy skill for data analysts to know how to create a word cloud in Power BI because it is a powerful way to visually represent textual data. Word clouds are useful in summarizing large amounts of text data and identifying patterns in it. They are also an effective way to communicate insights to stakeholders who may not have technical expertise.

Word clouds work best with data that consists of short, descriptive phrases or keywords, such as survey responses, customer feedback, or social media posts. In this tutorial, Gaelim is going to show how you can create a word Continue reading “How To Create A Word Cloud Of Any Shape In Power BI Using Python”

Convert CSV to Parquet using pySpark in Azure Synapse Analytics

You’ve got a bunch of CSV files and you’ve heard of Parquet. How do you convert them for Azure Synapse Analytics? Patrick shows you how using pySpark.

pyspark DataFrame
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/dataframe.html

pyspark.sql.DataFrameReader.load
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameReader.load.html

pyspark.sql.DataFrameWriter
https://spark.apache.org/docs/latest/api/python/reference/pyspark.sql/api/pyspark.sql.DataFrameWriter.html

📢 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
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Continue reading “Convert CSV to Parquet using pySpark in Azure Synapse Analytics”

How To Use Variables In DAX Formula With Power BI [2023 Update]

Learning how to use variables in DAX formulas is beneficial for data analysts because it allows them to simplify their code and make it easier to read and understand. Variables can be used to store intermediate results, making complex calculations more manageable and reducing the risk of errors. Additionally, using variables can help to optimize query performance, as calculations that are reused multiple times can be cached in memory.

Using variables can make it easier to debug code, as it allows analysts to isolate and test individual parts of the calculation. In this tutorial, Sam will demonstrate how you can Continue reading “How To Use Variables In DAX Formula With Power BI [2023 Update]”

How To Tune Up Your Power BI Data Model With The Best Practice Analyzer

Analyzing the performance of your Power BI data model is crucial to identify potential bottlenecks and optimize the model for faster data processing. It also helps to improve the user experience by reducing the query response time and increasing the overall efficiency of the Power BI reports.

How do you challenge yourself to determine if you’ve developed a good enough data model? The first thing that starts with Power BI is whether or not you built a good Star Schema. But even within the context of a Star Schema, there are better and worse ways to do things. In this video, Continue reading “How To Tune Up Your Power BI Data Model With The Best Practice Analyzer”

How To Integrate ChatGPT With Microsoft Outlook Using Power Automate

In recent months, the popularity of AI tools has risen significantly, and ChatGPT is one of them. These tools offer a range of benefits, including the ability to automate repetitive tasks, analyze data, and provide personalized recommendations. By leveraging the power of AI, organizations can streamline workflows and improve productivity.

Furthermore, AI tools can help identify patterns and insights that would be difficult for humans to detect, leading to more informed decision-making. In this tutorial, Henry is going to demonstrate how you can integrate ChatGPT with Microsoft Outlook using Power Automate.

*****Video Details*****
00:00 Introduction
00:25 Use case
02:57 How the API works
05:53 Power Continue reading “How To Integrate ChatGPT With Microsoft Outlook Using Power Automate”

Switch a Power BI Report’s dataset without needing Premium!

Want a dev and production environment in Power BI but don’t have Power BI Premium? Patrick shows you a way to switch a report from Dev to Production without Premium or without APIs.

📢 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
https://www.instagram.com/guyinacube/
https://guyinacube.com

***Gear***
🛠 Check out my Tools Continue reading “Switch a Power BI Report’s dataset without needing Premium!”

How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]

Knowing how to detect outliers in datasets and how to visualize them is important for data analysts because it helps them identify potential errors or anomalies in data that can skew statistical analyses and modeling results.

Outliers can also provide valuable insights into unusual or unexpected patterns in the data that may be indicative of underlying trends or issues, facilitating more effective data-driven decision-making. In this video, Sam is going to demonstrate how you can detect and visualize outliers using DAX in Power BI.

*****Video Details*****
00:00 Introduction
01:13 Determining the logic
03:44 Doing logic in a dynamic way
04:00 Criteria for outliers
05:22 Outlier detection logic
08:10 Continue reading “How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]”

How To Create Fully Dynamic Image Slicers In Power BI

Learning how to create dynamic picture slices in Power BI allows you to provide a more interactive and engaging experience for your audience. With dynamic picture slices, users can easily filter data and explore relationships visually, leading to better insights and decision-making. In this tutorial, Brian shows how you can spruce up your standard Power BI slicer into a fully dynamic image slicer.

*****Video Details*****
00:00 Introduction
00:44 Image source
01:52 Standardizing the image background
03:28 Chiclet slicer
05:00 Image hosting
06:40 Linking new table to customers table
09:50 Configuring the buttons
10:23 Formatting the image

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI Continue reading “How To Create Fully Dynamic Image Slicers In Power BI”

How To Test And Develop Color-blind Friendly Themes For Your Power BI Report

Using color-blind safe visuals in Power BI is important because around 5-10% of the population has some form of color blindness, which can make it difficult or impossible for them to distinguish certain colors. Failing to use color-blind safe visuals can lead to confusion and misinterpretation of data for people with color blindness, and ultimately lead to poor decision-making.

By using color-blind safe visuals, you can ensure that your data is accessible and understandable to a wider audience, including those with color vision deficiencies. In this tutorial, Brian shares a quick and easy way to check how color-blind friendly is your Continue reading “How To Test And Develop Color-blind Friendly Themes For Your Power BI Report”

Visually see where you BROKE the fold in Power Query

Rule #1 – DON’T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I’m guessing you didn’t even know it was there! Adam shows you where to go.

Query plan for Power Query (Preview)
https://learn.microsoft.com/power-query/query-plan

📢 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
rel=”nofollow”>http://www.facebook.com/guyinacube
https://www.instagram.com/guyinacube/
https://guyinacube.com

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

#PowerBI #PowerQuery #GuyInACube