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
My Son’s Math Challenge – From a Grade 2 Student.
Please see the solutions here: https://summalai.com/?p=3429
How to Use Excel EDATE Function
Summary The Excel EDATE function returns a date on the same day of the month, n months in the past or future. You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the future, and a negative value for dates Read More
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