switch_user_11-1

Power BI and SSRS Comparison

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 […]

switch_user_11-1

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 […]

switch_user_11-1

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 […]

switch_user_11-1

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 […]

switch_user_11-1

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 […]