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
Category: Power BI
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 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
How to Calculate Week-Start Date and Week-End Date
What’s the easiest way to calculate your weekly metrics when your data has a daily granularity? Simply create a new calculated column for the “week start date” or “week end date” to use in your visuals! This is very easy to do, but maybe a little counterintuitive to the new Power BI user. Let’s dive Read More