Merge columns (Power Query) Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 In Power Query, you can merge two or more columns in your query. You can merge columns to replace them with one merged column, or create a new merged column alongside the columns that are merged. You can only merge columns of a Text data Read More
Category: Power BI
How to Add a New Column by Lookup the Values from Another Table in Power BI – LOOKUPVALUE
This article is about LOOKUPVALUE function, which assigns values from another table. There doesn’t have to be a relationship between these tables. How to use it? In this example, we need to connect data from these two tables. One of them contains info about sales, but we miss the prices of items. The prices are Read More
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 Read More
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 Read More
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 Read More
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 Read More