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
- 3988 views
-
Power BI - Create quick measures
- 3:02
- Viewed 3988 times
-
Power BI - Create slicers
- 3:55
- Viewed 4014 times
-
Power BI - Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4343 times
-
Excel - Save your macro
- 2:59
- Viewed 3783 times
-
Power BI - Conditional formatting
- 3:35
- Viewed 3510 times
-
Power BI - What are measures?
- 2:58
- Viewed 2892 times
-
Power BI - Calculate function
- 4:22
- Viewed 3381 times
-
Excel - Edit a macro
- 3:29
- Viewed 3460 times
-
Creating a Report
- 2:54
- Viewed 9325 times
-
Introduction to Power Bi
- 1:29
- Viewed 7095 times
-
General Introduction
- 2:54
- Viewed 5012 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4343 times
-
Recovering your Data from different sources
- 3:26
- Viewed 4331 times
-
Introduction to Power BI Building Blocks
- 3:07
- Viewed 4216 times
-
Introduction to Power BI Desktop
- 2:52
- Viewed 4201 times
-
Create slicers
- 3:55
- Viewed 4014 times
-
Preparing, cleaning and transforming your Data
- 4:42
- Viewed 3879 times
-
Introduction to Power BI Mobile
- 2:15
- Viewed 3864 times
-
Creating and configuring a Dashboard
- 2:50
- Viewed 3721 times
-
Creating your Datasets
- 2:26
- Viewed 3713 times
-
Publishing your Report through the Power BI Service
- 2:59
- Viewed 3705 times
-
Introduction to the Query Editor
- 2:33
- Viewed 3583 times
-
Customising your Visuals
- 2:58
- Viewed 3569 times
-
Manipulating tiles in a Dashboard
- 3:26
- Viewed 3510 times
-
Conditional formatting
- 3:35
- Viewed 3510 times
-
Use the drill down filter
- 4:41
- Viewed 3501 times
-
Consulting and using a Dashboard
- 3:08
- Viewed 3461 times
-
Calculate function
- 4:22
- Viewed 3381 times
-
Turn on the drill down feature
- 2:23
- Viewed 3172 times
-
Add an alert to a visual
- 2:24
- Viewed 3087 times
-
Sharing and publishing your Dashboard
- 3:43
- Viewed 3076 times
-
Manage interactions
- 1:56
- Viewed 3049 times
-
Customising your Report
- 3:12
- Viewed 3011 times
-
Manage relations between data sources
- 2:37
- Viewed 2976 times
-
What are measures?
- 2:58
- Viewed 2892 times
-
Introduction to PowerBI
- 00:60
- Viewed 280 times
-
Remove a watermark
- 2:20
- Viewed 16658 times
-
How to add branching logic in Microsoft Forms
- 1:55
- Viewed 5825 times
-
Align flow chart shapes and add connectors
- 4:48
- Viewed 5540 times
-
Change font size, line spacing, and indentation
- 5:09
- Viewed 5493 times
-
Ink Equation
- 0:41
- Viewed 5302 times
-
Convert handwritten texts or drawings with Powerpoint
- 0:33
- Viewed 5225 times
-
AVERAGEIFS and IFERROR
- 4:45
- Viewed 5145 times
-
Change list formatting on the slide master
- 5:22
- Viewed 5142 times
-
Trigger text to play over a video
- 2:58
- Viewed 5112 times
-
Insert items in a presentation
- 2:38
- Viewed 5073 times
-
Convert a picture into Data with Excel
- 0:25
- Viewed 5034 times
-
Edit headers and footers on the slide master
- 4:56
- Viewed 4828 times
-
3D Maps
- 1:41
- Viewed 4826 times
-
Print Notes Pages as handouts
- 3:15
- Viewed 4733 times
-
Add a "Date" field to your form or quiz in Microsoft Forms
- 1:06
- Viewed 4718 times
-
Three ways to add numbers in Excel Online
- 3:15
- Viewed 4702 times
-
Add headers and footers to slides
- 3:52
- Viewed 4638 times
-
Add a sound effect to a transition
- 3:45
- Viewed 4570 times
-
Finalize and review a presentation
- 2:02
- Viewed 4552 times
-
Add sound effects to an animation
- 4:29
- Viewed 4526 times
-
Create a combo chart
- 1:47
- Viewed 4513 times
-
COUNTIFS and SUMIFS
- 5:30
- Viewed 4499 times
-
More complex formulas
- 4:17
- Viewed 4476 times
-
Save time by creating your form with quick import
- 2:20
- Viewed 4438 times
-
Create a new slide master and layouts
- 5:13
- Viewed 4368 times
-
Manage conditional formatting
- 4:30
- Viewed 4359 times
-
Animate charts and SmartArt
- 3:36
- Viewed 4355 times
-
Create dynamic visual title using the Selected Value function
- 5:42
- Viewed 4343 times
-
The nuts and bolts of VLOOKUP
- 3:05
- Viewed 4322 times
-
Functions and formulas
- 3:24
- Viewed 4321 times
-
Customize the slide master
- 4:38
- Viewed 4301 times
-
Use formulas to apply conditional formatting
- 4:20
- Viewed 4285 times
-
Work with a motion path
- 2:50
- Viewed 4280 times
-
Trigger an animation effect
- 2:29
- Viewed 4268 times
-
Start using Excel
- 4:22
- Viewed 4265 times
-
Manage drop-down lists
- 6:12
- Viewed 4256 times
-
Copy a VLOOKUP formula
- 3:27
- Viewed 4244 times
-
Prepare a basic handout
- 4:30
- Viewed 4244 times
-
Create a flow chart
- 3:27
- Viewed 4236 times
-
Build an org chart using the text pane
- 4:00
- Viewed 4233 times
-
New Chart types
- 1:52
- Viewed 4225 times
-
The SUMIF function
- 5:27
- Viewed 4223 times
-
VLOOKUP: How and when to use it
- 2:38
- Viewed 4183 times
-
Create slide content and save the template
- 4:50
- Viewed 4179 times
-
The SUM function
- 4:37
- Viewed 4157 times
-
How to simultaneously edit and calculate formulas across multiple worksheets
- 3:07
- Viewed 4157 times
-
Measure how people feel about something with the Likert scale in Microsoft Forms
- 2:02
- Viewed 4151 times
-
AVERAGEIF function
- 3:04
- Viewed 4150 times
-
Look up values on a different worksheet
- 2:39
- Viewed 4115 times
-
Using functions
- 5:12
- Viewed 4114 times
-
Insert columns and rows
- 4:16
- Viewed 4087 times
-
Advanced formulas and references
- 4:06
- Viewed 4073 times
-
How to link cells and calculate formulas across multiple worksheets
- 2:10
- Viewed 4063 times
-
Password protect workbooks and worksheets in detail
- 6:00
- Viewed 4056 times
-
Add numbers
- 2:54
- Viewed 4047 times
-
Animate pictures, shapes, text, and other objects
- 4:02
- Viewed 4040 times
-
Customize charts
- 4:28
- Viewed 4036 times
-
Print a worksheet on a specific number of pages
- 4:34
- Viewed 4032 times
-
Work with macros
- 4:40
- Viewed 4032 times
-
How to simultaneously view multiple worksheets
- 3:25
- Viewed 4029 times
-
Take conditional formatting to the next level
- 3:37
- Viewed 4024 times
-
Create slicers
- 3:55
- Viewed 4014 times
-
Create an automated workflow for Microsoft Forms with Power Automate
- 5:09
- Viewed 4013 times
-
Advanced filter details
- 4:13
- Viewed 3983 times
-
Customize colors and save the theme
- 4:45
- Viewed 3983 times
-
Subtract time
- 3:58
- Viewed 3982 times
-
Use slide masters to customize a presentation
- 3:07
- Viewed 3979 times
-
How to track and monitor values with the Watch Window
- 2:42
- Viewed 3979 times
-
Print headings, gridlines, formulas, and more
- 4:29
- Viewed 3974 times
-
Password protect workbooks and worksheets
- 2:27
- Viewed 3963 times
-
Freeze panes in detail
- 3:30
- Viewed 3962 times
-
Customize the design and layouts
- 5:06
- Viewed 3954 times
-
Create pie, bar, and line charts
- 3:13
- Viewed 3951 times
-
Create a template from a presentation
- 3:09
- Viewed 3950 times
-
Add a picture watermark
- 4:36
- Viewed 3947 times
-
AutoFilter details
- 3:27
- Viewed 3943 times
-
More print options
- 5:59
- Viewed 3941 times
-
Backgrounds in PowerPoint: First Steps
- 3:20
- Viewed 3937 times
-
Print slides, notes, or handouts
- 2:48
- Viewed 3917 times
-
Copying formulas
- 3:00
- Viewed 3913 times
-
Input and error messages
- 2:52
- Viewed 3908 times
-
IF with AND and OR
- 3:35
- Viewed 3905 times
-
Conditionally format dates
- 2:38
- Viewed 3904 times
-
Multiple choice questions in Microsoft Forms
- 2:14
- Viewed 3896 times
-
Create custom animations with motion paths
- 3:39
- Viewed 3887 times
-
Assign a button to a macro
- 2:49
- Viewed 3882 times
-
Sort details
- 4:46
- Viewed 3879 times
-
Header and footer details
- 3:41
- Viewed 3870 times
-
Insert headers and footers
- 2:02
- Viewed 3869 times
-
Drop-down list settings
- 4:14
- Viewed 3866 times
-
Combine data from multiple worksheets
- 2:50
- Viewed 3861 times
-
How to create a table
- 2:11
- Viewed 3858 times
-
Work with handout masters
- 4:34
- Viewed 3850 times
-
Change the theme background
- 5:38
- Viewed 3843 times
-
Animate pictures and shapes
- 4:17
- Viewed 3836 times
-
Print worksheets and workbooks
- 1:07
- Viewed 3829 times
-
Picture backgrounds: Two methods
- 4:58
- Viewed 3823 times
-
Print handouts
- 4:32
- Viewed 3796 times
-
Basic math
- 2:28
- Viewed 3791 times
-
Save your macro
- 2:59
- Viewed 3783 times
-
Operator order
- 2:04
- Viewed 3779 times
-
Screen recording
- 0:49
- Viewed 3778 times
-
Creating and managing a group
- 1:56
- Viewed 3766 times
-
Advanced IF functions
- 3:22
- Viewed 3757 times
-
Weighted average
- 2:06
- Viewed 3735 times
-
Cell references
- 1:34
- Viewed 3730 times
-
Use conditional formatting
- 2:02
- Viewed 3715 times
-
Copy a chart
- 2:59
- Viewed 3714 times
-
Improved version history
- 0:51
- Viewed 3710 times
-
Customize master layouts
- 4:57
- Viewed 3705 times
-
Add formulas and references
- 2:52
- Viewed 3667 times
-
Apply and change a theme
- 5:13
- Viewed 3667 times
-
Use slicers to filter data
- 1:25
- Viewed 3628 times
-
Conditionally format text
- 2:12
- Viewed 3621 times
-
Prepare and run your presentation
- 1:28
- Viewed 3608 times
-
How to use 3-D reference or tridimensional formulas
- 3:01
- Viewed 3606 times
-
Nested IF functions
- 3:30
- Viewed 3599 times
-
One click Forecasting
- 1:01
- Viewed 3595 times
-
Removing backgrounds in PowerPoint
- 2:45
- Viewed 3589 times
-
Combine a path with other effects
- 4:49
- Viewed 3585 times
-
Add headers and footers to a presentation
- 2:50
- Viewed 3573 times
-
Manage Your Working Time in MyAnalytics
- 0:34
- Viewed 3571 times
-
90 seconds about PowerPoint Slide Masters
- 1:17
- Viewed 3564 times
-
Copy and remove conditional formatting
- 1:11
- Viewed 3529 times
-
Create an org chart
- 3:09
- Viewed 3515 times
-
Conditional formatting
- 3:35
- Viewed 3510 times
-
AutoFill and Flash Fill
- 1:36
- Viewed 3509 times
-
Use the drill down filter
- 4:41
- Viewed 3501 times
-
Edit headers and footers for handouts
- 2:43
- Viewed 3474 times
-
Freeze or lock panes
- 1:06
- Viewed 3470 times
-
Edit a macro
- 3:29
- Viewed 3460 times
-
Build an org chart using SmartArt Tools
- 5:09
- Viewed 3460 times
-
Average a group of numbers
- 2:01
- Viewed 3445 times
-
Ink Equation
- 0:40
- Viewed 3444 times
-
Animate text
- 4:14
- Viewed 3443 times
-
New chart types
- 0:39
- Viewed 3441 times
-
Add staff members
- 2:57
- Viewed 3441 times
-
Design motion paths
- 2:30
- Viewed 3436 times
-
Drop-down lists
- 0:55
- Viewed 3422 times
-
Apply paths to layered pictures
- 5:28
- Viewed 3405 times
-
Sort and filter data
- 1:38
- Viewed 3404 times
-
Calculate function
- 4:22
- Viewed 3381 times
-
Present Live
- 3:13
- Viewed 3366 times
-
Create a sequence with line paths
- 6:42
- Viewed 3330 times
-
Make a reservation [Staff]
- 1:55
- Viewed 3244 times
-
Start using PowerPoint
- 2:06
- Viewed 3227 times
-
Add bullets to text
- 2:24
- Viewed 3206 times
-
Create a new calendar
- 2:55
- Viewed 3199 times
-
Trigger a video
- 4:06
- Viewed 3180 times
-
Turn on the drill down feature
- 2:23
- Viewed 3172 times
-
Add an alert to a visual
- 2:24
- Viewed 3087 times
-
Integrate Bookings into TEAMS
- 1:36
- Viewed 3063 times
-
Turn your Excel tables into real lists!
- 1:12
- Viewed 3062 times
-
Manage interactions
- 1:56
- Viewed 3049 times
-
Make a reservation [Customer]
- 2:13
- Viewed 3031 times
-
Create custom fields
- 1:21
- Viewed 3009 times
-
Manage relations between data sources
- 2:37
- Viewed 2976 times
-
Complete and Share a Schedule
- 2:02
- Viewed 2960 times
-
What are measures?
- 2:58
- Viewed 2892 times
-
Organise notes
- 2:57
- Viewed 2890 times
-
Add a service
- 2:03
- Viewed 2876 times
-
Easily measure user experience with Net Promoter Score in Microsoft Forms
- 1:32
- Viewed 2876 times
-
Create a Microsoft Forms form directly in OneDrive
- 1:33
- Viewed 2874 times
-
Import, create, edit and share documents
- 2:35
- Viewed 2856 times
-
Research in your notes
- 1:13
- Viewed 2854 times
-
Create a Schedule and Organise it with the Help of Groups
- 1:42
- Viewed 2844 times
-
Use template to prepare your Agile SCRUM meeting
- 2:50
- Viewed 2835 times
-
Create your first form or quiz in Microsoft Forms
- 2:12
- Viewed 2798 times
-
Create and organise a group
- 1:30
- Viewed 2793 times
-
Get a rating in Microsoft Forms
- 1:32
- Viewed 2787 times
-
Draw, sketch or handwrite notes
- 1:25
- Viewed 2786 times
-
Send your notes by email
- 0:42
- Viewed 2738 times
-
How Clock In Works
- 0:22
- Viewed 2704 times
-
Add a Visio diagram
- 1:23
- Viewed 2650 times
-
Manage our recent documents
- 2:24
- Viewed 2637 times
-
Make better tables
- 10 min
- Viewed 2636 times
-
Creating and managing campaigns
- 1:39
- Viewed 2610 times
-
Access other apps aroud Office 365
- 1:10
- Viewed 2600 times
-
Create a new shared booking page
- 2:32
- Viewed 2586 times
-
Insert an image in a cell with image function
- 3:01
- Viewed 2582 times
-
Password protect your notes
- 1:43
- Viewed 2580 times
-
Create dynamic drop down lists
- 3:26
- Viewed 2567 times
-
Save, share and share everything
- 0:49
- Viewed 2524 times
-
Add an Excel spreadsheet
- 1:31
- Viewed 2414 times
-
Creating or editing office documents in Engage
- 0:44
- Viewed 2405 times
-
Text before & after Function
- 4:57
- Viewed 2404 times
-
Insert online videos
- 0:41
- Viewed 2398 times
-
Imbrication OneNote / Teams
- 1:03
- Viewed 2381 times
-
Add files
- 1:26
- Viewed 2351 times
-
See who's collaborating
- 2:01
- Viewed 2346 times
-
Add items
- 2:04
- Viewed 2343 times
-
Meeting recordings in Microsoft Teams
- 1:13
- Viewed 2339 times
-
Make a reservation Employee]
- 1:50
- Viewed 2315 times
-
Create a video from the web app
- 1:20
- Viewed 2307 times
-
Use page templates
- 2:19
- Viewed 2293 times
-
Upload an existing video from your device
- 1:11
- Viewed 2290 times
-
Imbrication OneNote / Outlook
- 1:37
- Viewed 2289 times
-
How to Copy a Schedule
- 0:39
- Viewed 2287 times
-
Use formatting toolbar and styles to format forms and quizzes
- 1:55
- Viewed 2272 times
-
Find out your coworkers’ preferences by creating a “Ranking” question in Microsoft Forms
- 2:14
- Viewed 2263 times
-
Sync and sharing
- 0:28
- Viewed 2258 times
-
Add staff
- 2:36
- Viewed 2249 times
-
Create custom fields
- 1:12
- Viewed 2220 times
-
Record a live PowerPoint presentation
- 1:18
- Viewed 2204 times
-
Install Office on 5 devices
- 1:53
- Viewed 2197 times
-
Create a video from the mobile app
- 1:13
- Viewed 2189 times
-
Add or edit a thumbnail
- 0:59
- Viewed 2157 times
-
Use "Text" fields to create a contact form
- 2:16
- Viewed 2149 times
-
Let responders submit files in Microsoft Forms
- 1:58
- Viewed 2142 times
-
Engaging and animating a group
- 1:55
- Viewed 2025 times
-
Change chart type
- 1:29
- Viewed 2019 times
-
Make a reservation [Customer]
- 1:51
- Viewed 1903 times
-
Send a single form in multiple languages
- 1:21
- Viewed 1883 times
-
Add a service
- 2:28
- Viewed 1681 times
-
Save a PowerPoint presentation
- 1:10
- Viewed 1660 times
-
Use Recycle Bins to Restore Documents
- 01:49
- Viewed 519 times
-
Create a reminder for yourself
- 01:59
- Viewed 494 times
-
Use Documents in a Synchronized Library Folder
- 01:32
- Viewed 490 times
-
Send an Email and Create a Draft in Outlook
- 03:10
- Viewed 432 times
-
Insert Elements in Emails (Tables, Charts, Images)
- 02:49
- Viewed 423 times
-
Create and add a signature to messages
- 01:26
- Viewed 399 times
-
Create different types of events
- 01:46
- Viewed 386 times
-
Sort and filter emails
- 02:51
- Viewed 361 times
-
Edit and customize views
- 01:55
- Viewed 359 times
-
Manage Teams online meeting options
- 01:56
- Viewed 345 times
-
Create an Email Template
- 01:40
- Viewed 342 times
-
Add Accessible Tables and Lists
- 02:32
- Viewed 339 times
-
Save and Print a Message
- 01:48
- Viewed 337 times
-
Create a collaborative email with Microsoft Loop and Outlook
- 02:30
- Viewed 334 times
-
Change the default font of your emails
- 01:05
- Viewed 331 times
-
Delay Email Delivery
- 01:10
- Viewed 316 times
-
Improve Email Accessibility
- 02:02
- Viewed 312 times
-
Prepare for Time Out of Office (Viva Insights)
- 02:08
- Viewed 303 times
-
Search options
- 01:23
- Viewed 301 times
-
Improve the Accessibility of Images in Emails
- 01:18
- Viewed 295 times
-
Translate Emails in Outlook
- 01:32
- Viewed 292 times
-
Streamline Note-Taking with OneNote and Outlook
- 01:03
- Viewed 291 times
-
Use the Immersive Reader Feature
- 01:33
- Viewed 272 times
-
Dictate Your Email to Outlook
- 01:35
- Viewed 249 times
-
Instant alerts tailored to your activities
- 01:53
- Viewed 4 times
-
Seamless collaboration inside Microsoft Teams
- 01:22
- Viewed 4 times
-
Easy sharing with your team or organization
- 01:12
- Viewed 4 times
-
Relevant views to highlight your information
- 01:52
- Viewed 8 times
-
Clear insights through filters and sorting
- 02:06
- Viewed 4 times
-
A well-structured form for easy entry
- 01:17
- Viewed 4 times
-
The right column type for each data set
- 02:35
- Viewed 4 times
-
Custom columns to match your needs
- 02:09
- Viewed 3 times
-
Smooth updates and management for any list
- 01:06
- Viewed 3 times
-
Simple ways to add data to your list
- 01:06
- Viewed 4 times
-
Excel data turned into a dynamic list
- 02:08
- Viewed 4 times
-
A fully custom list built from scratch
- 01:34
- Viewed 4 times
-
A quick setup with ready-made templates
- 01:34
- Viewed 4 times
-
Mobile access to your lists made simple
- 01:37
- Viewed 6 times
-
The essentials of the Lists interface
- 02:01
- Viewed 5 times
-
The key reasons to use Microsoft Lists
- 02:01
- Viewed 4 times
-
Introduction to PowerBI
- 00:60
- Viewed 280 times
-
Introduction to Microsoft Outlook
- 01:09
- Viewed 265 times
-
Introduction to Microsoft Insights
- 02:04
- Viewed 257 times
-
Introduction to Microsoft Viva
- 01:22
- Viewed 290 times
-
Introduction to Planner
- 00:56
- Viewed 268 times
-
Introduction to Microsoft Visio
- 02:07
- Viewed 396 times
-
Introduction to Microsoft Forms
- 00:52
- Viewed 276 times
-
Introducing to Microsoft Designer
- 00:28
- Viewed 413 times
-
Introduction to Sway
- 01:53
- Viewed 351 times
-
Introducing to Word
- 01:00
- Viewed 254 times
-
Introducing to SharePoint Premium
- 00:47
- Viewed 242 times
-
Create a call group
- 01:15
- Viewed 440 times
-
Use call delegation
- 01:07
- Viewed 208 times
-
Assign a delegate for your calls
- 01:08
- Viewed 408 times
-
Ring multiple devices simultaneously
- 01:36
- Viewed 214 times
-
Use the "Do Not Disturb" function for calls
- 01:28
- Viewed 215 times
-
Manage advanced call notifications
- 01:29
- Viewed 226 times
-
Configure audio settings for better sound quality
- 02:08
- Viewed 360 times
-
Block unwanted calls
- 01:24
- Viewed 258 times
-
Disable all call forwarding
- 01:09
- Viewed 237 times
-
Manage a call group in Teams
- 02:01
- Viewed 257 times
-
Update voicemail forwarding settings
- 01:21
- Viewed 210 times
-
Configure call forwarding to internal numbers
- 01:02
- Viewed 214 times
-
Set call forwarding to external numbers
- 01:03
- Viewed 233 times
-
Manage voicemail messages
- 01:55
- Viewed 365 times
-
Access voicemail via mobile and PC
- 02:03
- Viewed 400 times
-
Customize your voicemail greeting
- 02:17
- Viewed 210 times
-
Transfer calls with or without an announcement
- 01:38
- Viewed 275 times
-
Manage simultaneous calls
- 01:52
- Viewed 239 times
-
Support third-party apps during calls
- 01:53
- Viewed 331 times
-
Add participants quickly and securely
- 01:37
- Viewed 222 times
-
Configure call privacy and security settings
- 02:51
- Viewed 225 times
-
Manage calls on hold
- 01:20
- Viewed 223 times
-
Live transcription and generate summaries via AI
- 03:43
- Viewed 230 times
-
Use the interface to make and receive calls
- 01:21
- Viewed 217 times
-
Action Function
- 04:18
- Viewed 218 times
-
Search Function
- 03:42
- Viewed 265 times
-
Date and Time Function
- 02:53
- Viewed 285 times
-
Logical Function
- 03:14
- Viewed 444 times
-
Text Function
- 03:25
- Viewed 278 times
-
Basic Function
- 02:35
- Viewed 235 times
-
Categories of Functions in Power FX
- 01:51
- Viewed 277 times
-
Introduction to Power Fx
- 01:09
- Viewed 277 times
-
The New Calendar
- 03:14
- Viewed 482 times
-
Sections
- 02:34
- Viewed 249 times
-
Customizing Views
- 03:25
- Viewed 239 times
-
Introduction to the New Features of Microsoft Teams
- 00:47
- Viewed 547 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.
Cette formation pourrait intéresser votre entreprise ?
Mandarine Academy vous offre la possibilité d'obtenir des catalogues complets et actualisés, réalisés par nos formateurs experts dans différents domaines pour votre entreprise