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
Month: February 2022
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
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