Power BI - Create quick measures Video
In this video, you will learn about using the "Tell Me" feature in PowerPoint 2016. This feature allows you to quickly find and use the features or actions you need by entering related words or phrases.
You can also get help or make a Smart Lookup on the typed word.
This will help you navigate PowerPoint more efficiently and save time.
- 3:02
- 4674 views
-
Power BI - Introduction to Power BI Mobile
- 2:15
- Viewed 5344 times
-
Power BI - Manage relations between data sources
- 2:37
- Viewed 3279 times
-
Power BI - What are measures?
- 2:58
- Viewed 3960 times
-
Power BI - Calculate function
- 4:22
- Viewed 3902 times
-
Power BI - Conditional formatting
- 3:35
- Viewed 3945 times
-
Power BI - Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4969 times
-
Power BI - Create slicers
- 3:55
- Viewed 5024 times
-
Power BI - Manage interactions
- 1:56
- Viewed 3494 times
-
Remove a watermark
- 2:20
- Viewed 39861 times
-
Change the default font for your emails
- 1:09
- Viewed 23509 times
-
Collapsible headings
- 3:03
- Viewed 20239 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20229 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19691 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16939 times
-
Create automatic reminders
- 4:10
- Viewed 13121 times
-
Protect a document shared by password
- 1:41
- Viewed 12048 times
-
Morph transition
- 0:43
- Viewed 11200 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10698 times
-
Remove a watermark
- 2:20
- Viewed 39861 times
-
Change the default font for your emails
- 1:09
- Viewed 23509 times
-
Collapsible headings
- 3:03
- Viewed 20239 times
-
How to recall or replace a sent email in Outlook Web
- 0:53
- Viewed 20229 times
-
Activate the features of Teams Premium
- 3:48
- Viewed 19691 times
-
How do I prevent the transfer of an email?
- 2:07
- Viewed 16939 times
-
Create automatic reminders
- 4:10
- Viewed 13121 times
-
Protect a document shared by password
- 1:41
- Viewed 12048 times
-
Morph transition
- 0:43
- Viewed 11200 times
-
Add a sound effect to a transition
- 3:45
- Viewed 10698 times
-
Block the transfer of a Teams meeting
- 02:40
- Viewed 17 times
-
Control the start of recording and transcription in Teams
- 03:03
- Viewed 15 times
-
Manage access to recordings and transcripts in Teams
- 02:59
- Viewed 12 times
-
Enable voice isolation in Teams
- 02:14
- Viewed 29 times
-
Add a collaborative page to a Teams channel
- 03:06
- Viewed 14 times
-
Manage a channel’s files with the Shared tab in Teams
- 03:34
- Viewed 22 times
-
Track conversations and organize channels in Teams
- 03:26
- Viewed 17 times
-
Create a team and set up the first channel in Teams
- 03:02
- Viewed 17 times
-
Create a newsletter in Outlook
- 02:23
- Viewed 50 times
-
Create an issue in an Outlook newsletter
- 03:27
- Viewed 54 times
Objectifs :
Understand how to create custom measures in Power BI Desktop using DAX for complex calculations, specifically focusing on calculating month-over-month changes in sales revenue.
Chapitres :
-
Introduction to Custom Measures in Power BI
Power BI Desktop typically automates calculations based on the types of fields and aggregations selected. However, for more complex and unique calculations, users may need to create their own measures using Data Analysis Expressions (DAX). This section will guide you through the process of creating custom measures. -
Creating a Quick Measure
To create a custom measure, you have two options: - From the Home tab, select 'Quick Measure'. - Alternatively, in the Fields pane, right-click on the item in question and select 'New Quick Measure' from the menu. This flexibility allows you to choose the method that best suits your workflow. -
Focusing on Sales Revenue
In this example, we will focus on calculating the monthly change in sales revenue. When the Quick Measure popup window appears, it suggests various quick measures such as aggregate per category, max per category, and filters. For our purpose, we will navigate to the 'Time Intelligence' category to find the 'Month-over-Month Change'. -
Setting Up the Measure
In the Quick Measure setup, you will see the fields recapped on the right side. For the base value, we will use the previously calculated measure for sales revenue. Drag and drop this measure into the designated area. Next, select the 'Order Date' from the sales table and slide it into the date field. Under 'Number of Periods', you can choose the frequency for the calculation, such as monthly, bi-monthly, or quarterly. For this example, we will leave it as is and click 'OK'. -
Visualizing the New Measure
Once the new measure is created, it will appear as 'Sales Revenue Month-to-Month' with a percentage. To visualize this data, select a clustered bar chart and drop the new measure into the visual. Additionally, select the months from the order data to display the changes over time. In future videos, we will explore how to format this visual to differentiate between negative and positive values.
FAQ :
What is Power BI Desktop used for?
Power BI Desktop is used for data visualization and business intelligence, allowing users to create reports and dashboards to analyze and share insights from their data.
How do I create a measure in Power BI?
To create a measure in Power BI, you can either use the 'Quick Measure' option from the Home tab or right-click on a field in the fields pane and select 'New Quick Measure'.
What is the purpose of DAX in Power BI?
DAX, or Data Analysis Expressions, is used in Power BI to create custom calculations and perform complex data analysis, enhancing the capabilities of your reports.
What is a month-over-month change?
A month-over-month change measures the difference in a specific metric, such as sales revenue, from one month to the next, providing insights into trends over time.
Can I visualize my data in Power BI?
Yes, Power BI allows you to create various visualizations, such as bar charts, line graphs, and pie charts, to represent your data effectively.
Quelques cas d'usages :
Sales Performance Analysis
Using Power BI to analyze sales revenue month-over-month can help sales teams identify trends, assess performance, and make informed decisions to improve sales strategies.
Financial Reporting
Finance departments can utilize DAX measures to create detailed financial reports that track revenue changes over time, aiding in budget forecasting and financial planning.
Marketing Campaign Effectiveness
Marketers can apply time intelligence functions in Power BI to evaluate the effectiveness of campaigns by comparing sales data before and after campaign launches.
Inventory Management
Businesses can use Power BI to monitor inventory levels and sales trends, allowing for better stock management and reducing excess inventory costs.
Glossaire :
Power BI Desktop
A business analytics tool by Microsoft that enables users to visualize data and share insights across their organization or embed them in an app or website.
Measures
Calculations used in Power BI to analyze data, which can be created using Data Analysis Expressions (DAX) to perform complex calculations.
Data Analysis Expressions (DAX)
A formula language used in Power BI, Excel, and other Microsoft tools to define custom calculations and queries on data.
Quick Measure
A feature in Power BI that allows users to create common calculations without writing DAX formulas manually.
Time Intelligence
A category of DAX functions that enables users to perform calculations based on dates and time periods, such as year-to-date totals or month-over-month changes.
Sales Revenue
The total income generated from sales of goods or services, before any expenses are deducted.
Clustered Bar Chart
A type of visual in Power BI that displays data in horizontal bars, allowing for easy comparison of different categories.