HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals. Read
more about
POWER BI ARCHIVES
May 13, 2021 by Reza Rad. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in. HOW TO USE ADDCOLUMNS FUNCTION IN DAX AND POWER BI How to use AddColumns DAX function in Power BI. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. POWER BI DESIGN TIP: DISABLE THE AUTO-DETECT RELATIONSHIP Power BI design tip, disable the auto-detect relationship. Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. DAY OF YEAR AND DAY OF QUARTER Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI MOVE MEASURES TO ANOTHER TABLE IN POWER BI The ability to move measures from one table to another table exists in Power BI, However, the process is not familiar for many users. Through my consulting and training work I have explained it to many of my clients. The process is simple and much better than re-creating the measure again and deleting the old Read more about Move Measures to Another Table in Power BI DYNAMIC BANDING OR GROUPING IN POWER BI Banding (or grouping or binning), means splitting a numeric data type into buckets or groups. Let’s say, we have customers with all ages, but we want to group them in age buckets of 10. one bucket would be 1 to 10, another from 11 to 20, etc. Here is an example of those buckets in the X-Axis of a chart; Banding can be done statically using GET THE DAY OF THE WEEK NAME AND NUMBER IN POWER BI USING If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX AGE BANDING IN POWER BI USING TREATAS DAX FUNCTION One of the most common types of banding or binning is banding based on a range. Let’s say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship BE CAREFUL WHEN MERGING ON TEXT FIELDS IN POWER BI USINGSEE MORE ON RADACAD.COM
HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals. Read more about
POWER BI ARCHIVES
May 13, 2021 by Reza Rad. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in. HOW TO USE ADDCOLUMNS FUNCTION IN DAX AND POWER BI How to use AddColumns DAX function in Power BI. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. POWER BI DESIGN TIP: DISABLE THE AUTO-DETECT RELATIONSHIP Power BI design tip, disable the auto-detect relationship. Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. DAY OF YEAR AND DAY OF QUARTER Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI MOVE MEASURES TO ANOTHER TABLE IN POWER BI The ability to move measures from one table to another table exists in Power BI, However, the process is not familiar for many users. Through my consulting and training work I have explained it to many of my clients. The process is simple and much better than re-creating the measure again and deleting the old Read more about Move Measures to Another Table in Power BI DYNAMIC BANDING OR GROUPING IN POWER BI Banding (or grouping or binning), means splitting a numeric data type into buckets or groups. Let’s say, we have customers with all ages, but we want to group them in age buckets of 10. one bucket would be 1 to 10, another from 11 to 20, etc. Here is an example of those buckets in the X-Axis of a chart; Banding can be done statically using GET THE DAY OF THE WEEK NAME AND NUMBER IN POWER BI USING If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX AGE BANDING IN POWER BI USING TREATAS DAX FUNCTION One of the most common types of banding or binning is banding based on a range. Let’s say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship BE CAREFUL WHEN MERGING ON TEXT FIELDS IN POWER BI USINGSEE MORE ON RADACAD.COM
EXTRACT PARTS OF A TEXT VALUE IN POWER BI USING A Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. SPLIT COLUMN BY DELIMITER IN POWER BI AND POWER QUERY Split column by delimiter in Power BI and Power Query. If you have a delimiter character (or part of the text) that is repeated multiple times, and you want to extract GET A FIELD VALUE FROM A RELATED TABLE IN POWER BI: DAX Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and
BASICS OF MODELING IN POWER BI: FACT TABLES Fact tables are the core of analysis in a data model. In the previous article, I explained what a dimension table is, and why we cannot have everything in one big table. In this article, you will learn about the fact table, and how it positioned in a data model, you will also learn how Read more about Basics of Modeling in Power BI: Fact Tables COMBINING TABLES IN POWER BI: UNION, EXCEPT, AND INTERSECT Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except CREATING A LIST OF NUMBERS OR DATES IN POWER BI USING If you ever need to create a list of numbers (either decimal or whole number), or list of dates and times, there is a very simple and useful function in DAX which helps. GenerateSeries is a simple function to use to create a list. In this article, I’ll explain how you can use this function. Read more about Creating a List of Numbers or Dates in Power BI using GenerateSeries Function in DAX FIND A TEXT TERM IN A FIELD IN POWER BI USING DAX In Power BI, there are multiple ways of searching for a text term inside a text field, you can use Power Query for doing this operation or calculations in DAX. In this post, I'll explain some functions in DAX that you can use to do this calculation. Most of these functions can be used inside
CREATING A SHARED DIMENSION IN POWER BI USING POWER QUERY For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to Read more about Creating a Shared Dimension in Power BI Using Power Query REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
WRITE CONDITIONAL STATEMENT USING SWITCH IN DAX AND POWER Conditional expressions are one of the most commonly used expressions in any language as well as DAX. However, in DAX, if you have multiple IF THEN expressions, there is an easier way of doing it; using a function called SWITCH, this blog is about how you can use switch function in DAX and Power BI to write a conditional expression. HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals. Read more about
SPLIT COLUMN BY DELIMITER IN POWER BI AND POWER QUERY Split column by delimiter in Power BI and Power Query. If you have a delimiter character (or part of the text) that is repeated multiple times, and you want to extract POWER BI ARCHIVES
May 13, 2021 by Reza Rad. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in. HOW TO USE ADDCOLUMNS FUNCTION IN DAX AND POWER BI How to use AddColumns DAX function in Power BI. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. SECURE THE SENSITIVE DATA IN POWER BI; DATA MASKING BETTER In my previous article/video, I explained how you can hide sensitive data from the user’s view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to create DAX measures, then there is a better and more secure way.
DAY OF YEAR AND DAY OF QUARTER Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI POWER BI DESIGN TIP: DISABLE THE AUTO-DETECT RELATIONSHIP Power BI design tip, disable the auto-detect relationship. Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. AGE BANDING IN POWER BI USING TREATAS DAX FUNCTION One of the most common types of banding or binning is banding based on a range. Let’s say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship DYNAMIC BANDING OR GROUPING IN POWER BI Banding (or grouping or binning), means splitting a numeric data type into buckets or groups. Let’s say, we have customers with all ages, but we want to group them in age buckets of 10. one bucket would be 1 to 10, another from 11 to 20, etc. Here is an example of those buckets in the X-Axis of a chart; Banding can be done statically using CREATE A PROFILING REPORT IN POWER BI: GIVE THE END USERSEE MORE ON RADACAD.COM
HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS In this article and video, I’ll share with you how to document everything from a Power BI file in a few clicks. The document output will have all the DAX code (measures, columns and tables) with the expressions, the tables with the Power Query scripts, information about visualization such as how many pages, bookmarks, visuals. Read more about
SPLIT COLUMN BY DELIMITER IN POWER BI AND POWER QUERY Split column by delimiter in Power BI and Power Query. If you have a delimiter character (or part of the text) that is repeated multiple times, and you want to extract POWER BI ARCHIVES
May 13, 2021 by Reza Rad. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in. HOW TO USE ADDCOLUMNS FUNCTION IN DAX AND POWER BI How to use AddColumns DAX function in Power BI. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. SECURE THE SENSITIVE DATA IN POWER BI; DATA MASKING BETTER In my previous article/video, I explained how you can hide sensitive data from the user’s view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to create DAX measures, then there is a better and more secure way.
DAY OF YEAR AND DAY OF QUARTER Power BI has some built-in, easy-to-use DAX functions to get the Day of Month and Day of the week, but nothing for Day of Year and Day of the quarter. These calculations, however, are very simple and easy to implement using other functions. This short blog and video explain a method to calculate those for Read more about Day of Year and Day of Quarter – DAX calculations for Power BI POWER BI DESIGN TIP: DISABLE THE AUTO-DETECT RELATIONSHIP Power BI design tip, disable the auto-detect relationship. Relationships are the heart of Power BI modeling, and Power BI Desktop has a way to help and identify the relationships based on the source, or the data. However, often, this ability to automatically detect a relationship is more troublesome than helping, especially when you deal with tables that are not designed for reporting. AGE BANDING IN POWER BI USING TREATAS DAX FUNCTION One of the most common types of banding or binning is banding based on a range. Let’s say, for example, you want to have a group of customers based on their age group. The age group banding can be created in Power Query at the data transformation stage. It can be created using the Grouping Read more about Age Banding in Power BI Using TREATAS DAX Function – Relationship DYNAMIC BANDING OR GROUPING IN POWER BI Banding (or grouping or binning), means splitting a numeric data type into buckets or groups. Let’s say, we have customers with all ages, but we want to group them in age buckets of 10. one bucket would be 1 to 10, another from 11 to 20, etc. Here is an example of those buckets in the X-Axis of a chart; Banding can be done statically using CREATE A PROFILING REPORT IN POWER BI: GIVE THE END USERSEE MORE ON RADACAD.COM
EXTRACT PARTS OF A TEXT VALUE IN POWER BI USING A Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. SPLIT COLUMN BY DELIMITER IN POWER BI AND POWER QUERY Split column by delimiter in Power BI and Power Query. If you have a delimiter character (or part of the text) that is repeated multiple times, and you want to extract GET A FIELD VALUE FROM A RELATED TABLE IN POWER BI: DAX Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and
SECURE THE SENSITIVE DATA IN POWER BI; DATA MASKING BETTER In my previous article/video, I explained how you can hide sensitive data from the user’s view. The method I explained there is a simple method, however, for a specific type of user. If you have users who are using Power BI Desktop to create reports on top of your model, and they are going to create DAX measures, then there is a better and more secure way.
COMBINING TABLES IN POWER BI: UNION, EXCEPT, AND INTERSECT Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except FIND A TEXT TERM IN A FIELD IN POWER BI USING DAX In Power BI, there are multiple ways of searching for a text term inside a text field, you can use Power Query for doing this operation or calculations in DAX. In this post, I'll explain some functions in DAX that you can use to do this calculation. Most of these functions can be used inside
CREATING A SHARED DIMENSION IN POWER BI USING POWER QUERY For a data warehouse professional, a shared dimension concept is always clear, and a star schema design always includes such type of entity. However, in the Power BI user’s world, there are many users who are not coming from a data warehousing background. It is necessary to understand some of the concepts in order to Read more about Creating a Shared Dimension in Power BI Using Power Query RELATIVE DATE SLICER IN POWER BI; SIMPLE, YET POWERFUL If you are using a date slicer in your Power BI report, a relative date slicer is one of the options to consider for sure. This is a very simple type of slicer to use, but very effective in terms of options that it provides for the user to slice and dice the data. REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
MODULE 01: LESSON 03 Module 01: Lesson 03 – T-test and analysis of variance Please sign up for the course before starting the lesson.. Module 01: Lesson 02 - Covariance and correlation HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS Academy: Online Learning. The best online learning website for all Power BI and AI topics. Many courses by Reza and Leila, all available at a monthly subscription or one-off option. POWER BI SUMMIT
Power BI Summit is a multi-day event bringing speakers from the Microsoft Power BI team’s product group and community experts and MVPs from all around the world. This conference is run virtually, and you can attend from anywhere, all you need is an internet connection and a computer.There are more than 100 sessions at this POWER BI HELPER
This version of the tool will give you these features. XMLA endpoint Connectivity. Connecting to Power BI objects (workspaces, dashboards, datasets, reports, dataflows) in the service. Documentation of all Power BI objects in the service. Downloading a version of all Power BI reports (PBIX files) from all workspaces to a local folder. TABLE WITH EMBEDDED CHART IN POWER BI USING R Visualization is any kind of graphical representation that enable us to: Exploration, it help us to get more deep insight through huge amount of data Discovery, It also gives extra vision Analysis, it can be used to find pattern Communication, visualization help us to communicate better A few years ago Dr. Andrew Abela published a good Read more about Table with Embedded Chart in Power BI COMBINING TABLES IN POWER BI: UNION, EXCEPT, AND INTERSECT Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except ORGANIZE POWER BI DAX MEASURES IN FOLDERS Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Read more about Organize Power BI DAX Measures in Folders GET THE DAY OF THE WEEK NAME AND NUMBER IN POWER BI USING If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX CHANGE THE COLUMN OR MEASURE VALUE IN A POWER BI VISUAL BYSEE MORE ON RADACAD.COM
REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
HAVE MORE CHARTS BY WRITING R CODES INSIDE POWER BI: PART Power BI recently able users to embedded the R graphs in Power BI. There are some R visuals that it would be very nice to have them in Power BI. What is R ? Based on Wikipedia, R is an open source programming language and software environment for statistical computing and graphics that is supported Read more about Have more Charts by writing R codes inside Power BI: Part 1 HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS Academy: Online Learning. The best online learning website for all Power BI and AI topics. Many courses by Reza and Leila, all available at a monthly subscription or one-off option. POWER BI SUMMIT
Power BI Summit is a multi-day event bringing speakers from the Microsoft Power BI team’s product group and community experts and MVPs from all around the world. This conference is run virtually, and you can attend from anywhere, all you need is an internet connection and a computer.There are more than 100 sessions at this POWER BI HELPER
This version of the tool will give you these features. XMLA endpoint Connectivity. Connecting to Power BI objects (workspaces, dashboards, datasets, reports, dataflows) in the service. Documentation of all Power BI objects in the service. Downloading a version of all Power BI reports (PBIX files) from all workspaces to a local folder. TABLE WITH EMBEDDED CHART IN POWER BI USING R Visualization is any kind of graphical representation that enable us to: Exploration, it help us to get more deep insight through huge amount of data Discovery, It also gives extra vision Analysis, it can be used to find pattern Communication, visualization help us to communicate better A few years ago Dr. Andrew Abela published a good Read more about Table with Embedded Chart in Power BI COMBINING TABLES IN POWER BI: UNION, EXCEPT, AND INTERSECT Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except ORGANIZE POWER BI DAX MEASURES IN FOLDERS Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Read more about Organize Power BI DAX Measures in Folders GET THE DAY OF THE WEEK NAME AND NUMBER IN POWER BI USING If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX CHANGE THE COLUMN OR MEASURE VALUE IN A POWER BI VISUAL BYSEE MORE ON RADACAD.COM
REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
HAVE MORE CHARTS BY WRITING R CODES INSIDE POWER BI: PART Power BI recently able users to embedded the R graphs in Power BI. There are some R visuals that it would be very nice to have them in Power BI. What is R ? Based on Wikipedia, R is an open source programming language and software environment for statistical computing and graphics that is supported Read more about Have more Charts by writing R codes inside Power BI: Part 1 EXTRACT PARTS OF A TEXT VALUE IN POWER BI USING A Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. GET A FIELD VALUE FROM A RELATED TABLE IN POWER BI: DAX Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and
POWER BI ARCHIVES
May 13, 2021 by Reza Rad. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in. SCHEDULED SNAPSHOT OF THE POWER BI DATA AND REPORT The Power BI report is creating a snapshot of report and dataset every day (it can be on other schedules too, weekly, or monthly etc). The copy of the report can be created in another workspace in Power BI service as below: The copy of Power BI report or dataset is not the only thing that can be scheduled. You can also schedule part of data (as
GENERATING ROW NUMBER IN POWER BI VISUALIZATION USING DAX I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let’s see how this is possible. Sample model I have a Read more about Generating Row Number in Power BI Visualization Using SORT A COLUMN WITH A CUSTOM ORDER IN POWER BI Summary. In Power BI, You can set any custom order you want. the trick is to do these steps: Create a sort order table with a sort order column that has the same cardinality as the label column. Combine that table with the rest of the model (Using Power Query and Merge, or The relationship and calculated column) Sort the label column by the REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
MODULE 01: LESSON 03 Module 01: Lesson 03 – T-test and analysis of variance Please sign up for the course before starting the lesson.. Module 01: Lesson 02 - Covariance and correlation UPCOMING EVENTS
Difinity is the largest Microsoft Data and AI, Power Platform, BI, and Analytics Conference in New Zealand and Australia. IT Decision Makers, Developers, Analysts, IT Professionals, BI SUBSTRING IN DAX: HOW TO GET PART OF STRING FIELD IN POWER Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from "Reza Rad", if I want to get the HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS Academy: Online Learning. The best online learning website for all Power BI and AI topics. Many courses by Reza and Leila, all available at a monthly subscription or one-off option. POWER BI SUMMIT
Power BI Summit is a multi-day event bringing speakers from the Microsoft Power BI team’s product group and community experts and MVPs from all around the world. This conference is run virtually, and you can attend from anywhere, all you need is an internet connection and a computer.There are more than 100 sessions at this POWER BI HELPER
This version of the tool will give you these features. XMLA endpoint Connectivity. Connecting to Power BI objects (workspaces, dashboards, datasets, reports, dataflows) in the service. Documentation of all Power BI objects in the service. Downloading a version of all Power BI reports (PBIX files) from all workspaces to a local folder. TABLE WITH EMBEDDED CHART IN POWER BI USING R Visualization is any kind of graphical representation that enable us to: Exploration, it help us to get more deep insight through huge amount of data Discovery, It also gives extra vision Analysis, it can be used to find pattern Communication, visualization help us to communicate better A few years ago Dr. Andrew Abela published a good Read more about Table with Embedded Chart in Power BI COMBINING TABLES IN POWER BI: UNION, EXCEPT, AND INTERSECT Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except ORGANIZE POWER BI DAX MEASURES IN FOLDERS Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Read more about Organize Power BI DAX Measures in Folders GET THE DAY OF THE WEEK NAME AND NUMBER IN POWER BI USING If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX CHANGE THE COLUMN OR MEASURE VALUE IN A POWER BI VISUAL BYSEE MORE ON RADACAD.COM
REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
HAVE MORE CHARTS BY WRITING R CODES INSIDE POWER BI: PART Power BI recently able users to embedded the R graphs in Power BI. There are some R visuals that it would be very nice to have them in Power BI. What is R ? Based on Wikipedia, R is an open source programming language and software environment for statistical computing and graphics that is supported Read more about Have more Charts by writing R codes inside Power BI: Part 1 HOME - RADACADTRAININGCONSULTINGARTICLESBOOKSVIDEOSTOOLS Academy: Online Learning. The best online learning website for all Power BI and AI topics. Many courses by Reza and Leila, all available at a monthly subscription or one-off option. POWER BI SUMMIT
Power BI Summit is a multi-day event bringing speakers from the Microsoft Power BI team’s product group and community experts and MVPs from all around the world. This conference is run virtually, and you can attend from anywhere, all you need is an internet connection and a computer.There are more than 100 sessions at this POWER BI HELPER
This version of the tool will give you these features. XMLA endpoint Connectivity. Connecting to Power BI objects (workspaces, dashboards, datasets, reports, dataflows) in the service. Documentation of all Power BI objects in the service. Downloading a version of all Power BI reports (PBIX files) from all workspaces to a local folder. TABLE WITH EMBEDDED CHART IN POWER BI USING R Visualization is any kind of graphical representation that enable us to: Exploration, it help us to get more deep insight through huge amount of data Discovery, It also gives extra vision Analysis, it can be used to find pattern Communication, visualization help us to communicate better A few years ago Dr. Andrew Abela published a good Read more about Table with Embedded Chart in Power BI COMBINING TABLES IN POWER BI: UNION, EXCEPT, AND INTERSECT Power Query is often the engine used for combining data tables, especially using Merge or Append. However, sometimes, you might need to do that operation in DAX. An example of that is when you want to create that combination only virtually as part of a measure calculation that evaluates dynamically. In this article, I’ll explain Read more about Combining Tables in Power BI: Union, Except ORGANIZE POWER BI DAX MEASURES IN FOLDERS Although very simple, still I see many Power BI reports with no organized way of separating measures. When you use Power BI for a while, you will gradually have more DAX measures and calculations, and having them organized under folders is always helpful. In this very short article, I’ll explain how you can use Display Read more about Organize Power BI DAX Measures in Folders GET THE DAY OF THE WEEK NAME AND NUMBER IN POWER BI USING If you don’t have a date table with a column that represents the day of the week name (Saturday, Sunday, Monday etc) or number (from zero to six, or from one to seven), and you just have a date field, which you want to quickly get the day name of the week, here is a Read more about Get the Day of the Week Name and Number in Power BI Using DAX CHANGE THE COLUMN OR MEASURE VALUE IN A POWER BI VISUAL BYSEE MORE ON RADACAD.COM
REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
HAVE MORE CHARTS BY WRITING R CODES INSIDE POWER BI: PART Power BI recently able users to embedded the R graphs in Power BI. There are some R visuals that it would be very nice to have them in Power BI. What is R ? Based on Wikipedia, R is an open source programming language and software environment for statistical computing and graphics that is supported Read more about Have more Charts by writing R codes inside Power BI: Part 1 EXTRACT PARTS OF A TEXT VALUE IN POWER BI USING A Reza Rad is a Microsoft Regional Director, an Author, Trainer, Speaker and Consultant. He has a BSc in Computer engineering; he has more than 20 years’ experience in data analysis, BI, databases, programming, and development mostly on Microsoft technologies. GET A FIELD VALUE FROM A RELATED TABLE IN POWER BI: DAX Sometimes, in Power BI, you need to access a field’s value from another table that somehow is related to the existing table. You can use Power Query transformations such as combining Merge with something else. However, this can be needed when you write a DAX expression too. In this article and
POWER BI ARCHIVES
May 13, 2021 by Reza Rad. AddColumns is a DAX function that is helpful often when writing calculations in Power BI. In this article and video, I’ll explain how you can use it to add calculated columns on the fly to the virtual tables in measures or directly in a table. AddColumns DAX Tabular Function AddColumns is a tabular function in. SCHEDULED SNAPSHOT OF THE POWER BI DATA AND REPORT The Power BI report is creating a snapshot of report and dataset every day (it can be on other schedules too, weekly, or monthly etc). The copy of the report can be created in another workspace in Power BI service as below: The copy of Power BI report or dataset is not the only thing that can be scheduled. You can also schedule part of data (as
GENERATING ROW NUMBER IN POWER BI VISUALIZATION USING DAX I have previously explained how to generate a row-number using Power Query. That method is good for pre-calculating row-numbers in the table. However, sometimes, you want to calculate the row number in a visual, based on something dynamic. That is where DAX comes handy. Let’s see how this is possible. Sample model I have a Read more about Generating Row Number in Power BI Visualization Using SORT A COLUMN WITH A CUSTOM ORDER IN POWER BI Summary. In Power BI, You can set any custom order you want. the trick is to do these steps: Create a sort order table with a sort order column that has the same cardinality as the label column. Combine that table with the rest of the model (Using Power Query and Merge, or The relationship and calculated column) Sort the label column by the REPLACE BLANK WITH ZERO IN POWER BI VISUALS SUCH AS CARD If you use a field in a visual and based on a combination of slicer selection, that field doesn’t have any value, you might see blank in the visual. If you want to replace that blank to zero, here is a trick for you. a very simple trick that you can use anywhere easily. Sample Read more about Replace BLANK with Zero in Power BI Visuals Such as Card
MODULE 01: LESSON 03 Module 01: Lesson 03 – T-test and analysis of variance Please sign up for the course before starting the lesson.. Module 01: Lesson 02 - Covariance and correlation UPCOMING EVENTS
Difinity is the largest Microsoft Data and AI, Power Platform, BI, and Analytics Conference in New Zealand and Australia. IT Decision Makers, Developers, Analysts, IT Professionals, BI SUBSTRING IN DAX: HOW TO GET PART OF STRING FIELD IN POWER Substring is one of the most common functions in many languages, However, there is no function named Substring DAX. There is a very simple way of doing it, which I am going to explain in this post. Substring means getting part of a string, for example from "Reza Rad", if I want to get the Toggle navigation
Skip to content
* __Home
* __Training
* __Consulting
* __Blog Articles
* __Books
* __Videos
* __Tools
* __About
* __Contact Us
* __Login to Academy THE CENTRAL HUB FOR ONLINE TRAINING AND REMOTE CONSULTING ON POWER BI AND AI
Online Training
Remote
Consulting
WE CAN HELP YOU WITH below services to help you learn and overcome your day to day challenges with Power BI and AI ACADEMY: ONLINE LEARNING ______
The best online learning website for all Power BI and AI topics. Many courses by Reza and Leila, all available at a monthly subscription or one-off option.
Details
REMOTE COACHING AND CONSULTING ______
