There are different types of joins available in SQL: INNER JOIN: returns rows when there is a match in both tables. LEFT JOIN: returns all rows from the left table, even if there are no matches in the right table. RIGHT JOIN: returns all rows from the right table, even if there are no matches Read More
How to Fix Total Row is Displaying 0 Instead of Real Sum
Sample problem: I have employee data, which I used to create a table with headcounts and a measure of % Female: The tricky part is when I want a count of how many countries have % Female >= 30%. I added a measure: Meets Criteria = IF ((Female HC]/ [Total HC]) >= 0.3, 1, 0) It Read More
How to Set up Alerts in the Power BI
Set alerts to notify you when data in your dashboards changes beyond the limits you set. You can set alerts on tiles in your My Workspace. You can also set alerts if someone shares a dashboard that’s in a Premium capacity. If you have a Power BI Pro license, you can set alerts on tiles in Read More
How to Remove Duplicates by Using Power Query for Excel
Open up the Power Query Editor. Go to Home > Remove Rows > Remove Duplicates STEP 4: Click Close & Load from the Home tab and this will open up a brand new worksheet in your Excel workbook with the cleaned table. You now have your new table with the remove duplicates power query! This completes our tutorial on How to Remove Duplicates Read More
How to Fix the Problem of “A circular dependency was detected”
A circular dependency is detected whenever two objects reference each other, in such a way that Power BI cannot process the objects. The details of why this happens are outlined in this article: Understanding Circular Dependencies in Tabular and PowerPivot – SQLBI. Here, the focus is solely on what to do to solve the scenario. We Read More
PERCENTILE vs PERCENTILE.INC vs PERCENTILE.EXC
PERCENTILE.EXC and PERCENTILE.INC differs only in the way the possibly-non-integer rank is calculated. For PERCENTILE.INC (and PERCENTILE) the calculated rank is K*(N-1)+1. For PERCENTILE.EXC the calculated rank is K*(N+1). Percentile Percentile is a statistics term used to describe the Nth observation in a data set after sorting in ascending order. For example, 40th percentile (P40) Read More