![BI Land](/img/default-banner.jpg)
- 21
- 157 780
BI Land
Registrace 12. 12. 2021
Welcome to BI Land! This channel is intended to teach you Power BI and DAX. We are going to go step by step through real world practical examples.
Select Multiple Measures in Power BI Slicer
In this Video, we are going to see how to select multiple measures from a slicer and have the chart show those measures. It is especially useful when you want to see different calculations selectively in your visuals.
Different Measures Based on Slicer Selection:
czcams.com/video/tljRYGz15PA/video.htmlsi=np-r7Ay4qYKbzkgN
BI Land: czcams.com/users/BILand
Watch this to learn 12 most used DAX functions in Power BI:
czcams.com/video/d-zPxpkgISc/video.html
Subscribe to My Channel:
www.youtube.com/@BILand/videos?sub_confirmation=1
Different Measures Based on Slicer Selection:
czcams.com/video/tljRYGz15PA/video.htmlsi=np-r7Ay4qYKbzkgN
BI Land: czcams.com/users/BILand
Watch this to learn 12 most used DAX functions in Power BI:
czcams.com/video/d-zPxpkgISc/video.html
Subscribe to My Channel:
www.youtube.com/@BILand/videos?sub_confirmation=1
zhlédnutí: 572
Video
How to Design Power BI Report Professionally
zhlédnutí 460Před 6 měsíci
Report design is extremely important in the professional world. Even if your report does a great job with numbers and calculations, if it does not look great and pro, most likely no one is going to use it. Don’t waste any time and apply these steps to make your Power BI report stand out. BI Land: czcams.com/users/BILand How to Create a Home Page in Power BI czcams.com/video/-9TbvHkn5HA/video.ht...
How to Connect to Oracle Database via Power BI - Issues Fixed
zhlédnutí 5KPřed 7 měsíci
In this video, I will show how to connect to an oracle database, load data into Power BI and solve the most recurrent issues. BI Land: czcams.com/users/BILand Watch this to learn 12 most used DAX functions in Power BI: czcams.com/video/d-zPxpkgISc/video.html
How to Use MEASURE FILTERS in Power BI
zhlédnutí 9KPřed 10 měsíci
In this video, we are going to learn how to apply a measure filter in Power BI. In many cases, you will need to use a measure to filter your visuals. Let’s learn this with two examples. We will see the potential dangers of measure filters as well. 0:00 Introduction 01:29 Apply a measure as filter - example 1: measure filter on slicer for date range. 07:19 Apply a measure as filter - example 2: ...
How to Make Dynamic Custom Arrows in Power BI
zhlédnutí 4,7KPřed 11 měsíci
In this video, we are going to make customs arrows to be able to visualize the KPIs much better. We will use DAX measure and conditional formatting. Creating arrows or the icons using measure will provide you much more possibilities in presenting your indicators to top management. BI Land: czcams.com/users/BILand Compare Two Time Periods or Dates Dynamically: (HIGHLY RECOMMENDED) czcams.com/vid...
How to Create Dynamic Top N in Power BI Slicer
zhlédnutí 4,5KPřed 11 měsíci
In this video, we are going to make a measure that works dynamically according to the selection of the top in the slicer. It will also respect all other filters if selected. Moreover, you will learn the difference between ALL and ALLSELECTED in DAX BI Land: czcams.com/users/BILand Watch this to learn 12 most used DAX functions in Power BI: czcams.com/video/d-zPxpkgISc/video.html Watch this to l...
12 Most Used DAX Functions in Power BI
zhlédnutí 3,3KPřed rokem
In this video we are going to learn 12 most used DAX functions in Power BI. This is part of the “absolutely essentials” for Power BI. We will use each function with practical and real-world business examples. 0:00 Introduction 00:22 SUM Function in Power BI 02:07 COUNT Function in Power BI 04:02 CALCULATE, FILTER and BLANK DAX Functions 07:22 MAX and MIN in Power BI 09:05 IF and HASONEFILTER Fu...
How to Lookup in Power BI - Advanced
zhlédnutí 1,2KPřed rokem
In this video, we are going to see how to look up a value between two values in another table with no unique keys between the two tables. You will surely encounter this need in your business as a data analyst.This video provides practical example to comprehend the subject fully. It will also help you understand building filter table inside a variable in Power BI and SSAS. BI Land: czcams.com/us...
How to Create a Home Page in Power BI
zhlédnutí 10KPřed rokem
In this video, we are going to see how to create a home page in Power BI for easier navigation through other pages. Home page is also useful to apply main filters before entering the reports pages. Additionally, we can host important information concerning the whole report in the Home Page. This video provides practical tips that are very useful for building reports in real business world. 0:00...
How to Show Several Months Based on Single Slicer Selection
zhlédnutí 1,4KPřed rokem
If you need to select single month but show several previous months, or from the beginning of the year in your charts, watch this video. We often face this kind of requirements in real BI projects. This video will help you boost your DAX. In this video, we will see the following DAX functions: DATESINPERIOD REMOVEFILTERS KEEPFILTERS Master Calendar in Power BI and SSAS: czcams.com/video/Oq5WOmo...
How to Show Power BI Report on the Last Available Date by Default
zhlédnutí 7KPřed 2 lety
Imagine you have published a report to power BI services, and then you have scheduled the dataset to be refreshed. How can you make your report to be filtered always on the last available date after a refresh.? It means that you want your report to show always according to the last date available in your data. In this video, we are going to see how to make this possible. Enjoy it! 0:00 Introduc...
How to Use Variables in Power BI - Replace EARLIER
zhlédnutí 1,5KPřed 2 lety
In this video, we are going to use variables to replace EARLIER Dax function with 4 practical examples. This video will help you to understand how variables really work in power BI and SSAS Enjoy it! 0:00 Introduction 0:44 Example 1: Prior highest record 7:39 Example 2: Ranking 10:39 Example 3: Percent of total 13:25 Example 4: Next study date 16:35 Conclusion Watch this to learn EARLIER thorou...
The Most Complex DAX Function Made Easy
zhlédnutí 3,4KPřed 2 lety
In this video, we are going to deep dive into understanding EARLIER Dax function with 4 practical examples. It is true that Variables now can replace EARLIER function. Yet understanding EARLIER will help deepen your DAX knowledge tremendously. Enjoy the video! 0:00 Introduction 1:10 Example 1: Prior Highest Record 10:45 Example 2: Ranking 16:45 Example 3: Percent of Total 21:05 Example 2: Next ...
Dynamic Segmentation & Clustering in Power BI - Boost Your DAX
zhlédnutí 8KPřed 2 lety
In this video, we learn how to make dynamic segmentation. It is a very useful method to cluster the fields based on measures. The DAX used for this subject is somehow advanced, yet it is explained thoroughly. Enjoy the video!
How to Make Dynamic Axis Using DAX in Power BI
zhlédnutí 4,2KPřed 2 lety
In this video, we are going to explore making dynamic axes using DAX measures. This method will allow you to manage complex as well as easy cases. We will use UNION, SELECTEDCOLUMNS, DISTINCT, SWITCH, SELECTEDVALUE, PREVIOUSQUARTER, PREVIOUSYEAR and some other DAX functions. 0:00 Introduction 3:38 Combine different columns into one in power BI 10:05 Measure for dynamic axis 16:06 Percentage cha...
Calendar in Power BI, Everything You Need to Know
zhlédnutí 17KPřed 2 lety
Calendar in Power BI, Everything You Need to Know
Different Measures Based on Slicer Selection in Power BI
zhlédnutí 27KPřed 2 lety
Different Measures Based on Slicer Selection in Power BI
Different Calculations Based on Hierarchy Levels Inside One Measure in Power BI
zhlédnutí 9KPřed 2 lety
Different Calculations Based on Hierarchy Levels Inside One Measure in Power BI
How to Compare Different Time Periods or Date Ranges in Power BI or SSAS
zhlédnutí 12KPřed 2 lety
How to Compare Different Time Periods or Date Ranges in Power BI or SSAS
How to Compare Two Time Periods or Dates Dynamically in Power BI (P1: Years)
zhlédnutí 27KPřed 2 lety
How to Compare Two Time Periods or Dates Dynamically in Power BI (P1: Years)
Create Your FIRST Power BI Report, Comprehensive Tutorial for Beginners
zhlédnutí 812Před 2 lety
Create Your FIRST Power BI Report, Comprehensive Tutorial for Beginners