Calculated Columns and Measures in DAX. One of the first concepts to learn in DAX is the difference between calculated columns and measures. This article shortly recaps the differences and describes when to use each one. Calculated columns When you create a data model in Power Pivot for Excel, Analysis Services Tabular, or Power BI Read More
Category: Power BI
Which Is Better? Power BI Vs. Tableau
In the search for data visualisation or business intelligence tool, we have two options to adopt; they are nothing but Power BI and Tableau. Both products are very similar to each other. Now it’s time for us to look at which is better. Power BI Vs. Tableau: A Useful Comparison We can choose the best Read More
Understand DAX operators in Power BI
The Data Analysis Expression (DAX) language uses operators to create expressions that compare values, perform arithmetic calculations, or work with strings. Types of operators There are four different types of calculation operators: arithmetic, comparison, text concatenation, and logical. Arithmetic operators To perform basic mathematical operations such as addition, subtraction, or multiplication; combine numbers; and produce Read More
Understand “Analyze in Excel” in Power BI
With Analyze in Excel, you can bring Power BI datasets into Excel, and then view and interact with them using PivotTables, charts, slicers, and other Excel features. To use Analyze in Excel you must first download the feature from Power BI, install it, and then select one or more datasets to use in Excel. This article shows you Read More
How to Solve DAX Time Zone Issue in Power BI
Power BI is a cloud service, and that means Power BI files are hosted somewhere. Some DAX functions such as Date/Time functions work on system date/time on the server their file is hosted on. So If you use DAX functions such as TODAY() or NOW() you will not get your local date/time, You will fetch Read More
How to Apply Many-Many Relationships in Power BI Desktop
With relationships with a many-many cardinality in Power BI Desktop, you can join tables that use a cardinality of many-to-many. You can more easily and intuitively create data models that contain two or more data sources. Relationships with a many-many cardinality are part of the larger composite models capabilities in Power BI Desktop. A relationship with a many-many cardinality in Power BI Desktop is Read More