Below is the comparison table between Power BI and SSRS. Basis For Comparison Power BI SSRS Definition Power bi stands for power business intelligence which is the product of Microsoft. Used for analysis and generating the reports from the cloud as well as server SSRS stands for SQL server reporting services, it is also a […]
Category: Power BI
Power BI: CALCULATETABLE function DAX
CALCULATETABLE function is a power bi filter function in DAX that evaluates a table expression in a context modified by the given filters. It returns a table of values. CALCULATETABLE(<expression>,<filter1>,<filter2>,…) <expression> is a table expression to be evaluated. A measure can not be used as expression. <filter1>,<filter2>.. is a Boolean expression or a table expression […]
How to Calculate Number of Days Between Two Dates in Power BI
Problem: I have a table with customer information, including a target start date of the contract and the actual start date. I would like to add an additional column showing the number of days the contract actually started before (negative number) of after (positive number) the target start date. Solution1: You can create a calculated […]
How to Remove Vertical Gray Bar in a Text Box in Power BI
The problem is as below: Vertical gray bars keep appearing on the right side of my text boxes. They are wider than the ones that appear on the right side of cards, and usually appear later, when I’ve moved on to a different tile. They do not seem to show up when I view the same […]
Understand the Difference Between Calculated Columns and Measures in Power BI
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 […]
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 […]