If you want to become an Power BI expert, check out all our helpful tutorials on Microsoft Power BI. All the tutorials are written by experts and followed steps properly and written with screenshots. You can email us if you still have questions for us.
Our operations team wanted to know how long orders sat in the warehouse before shipping, which orders were still open, and how many shipped after their due date. Every one of those questions is a date difference, and in Power BI DATEDIFF answers most of them in one line. In this tutorial, I’ll show you … Read more >>>
Quantity times price, an amount times a tax rate, last year’s sales times a growth factor: some kind of multiplication shows up in almost every Power BI report I build. The operator itself is simple, but there’s one common mistake that quietly produces wrong totals, and I see it in reports all the time. In … Read more >>>
Date filters in Power BI trip up a lot of people, not because they’re complicated, but because there are several ways to do the same thing, and picking the wrong one creates unnecessary headaches. In this tutorial, we will see how to filter dates in Power BI using every practical approach: from the simple relative … Read more >>>
Recently, I have been working with the slicer visual in Power BI. A client requested a system to track team performance using various visualizations based on employee data. The client asked us to filter and display employee data whose designation contains the Manager role. In this Power BI tutorial, let’s see how to use contains … Read more >>>
A sales manager once sent me a screenshot of a Power BI report showing $696 million in revenue. The company sells about $720 thousand a year. The measure multiplied total quantity by total price, and that one wrong function choice inflated the number almost a thousand times. SUM and SUMX look similar, but they work … Read more >>>
Your sales data is split across three tables: online orders, in-store orders, and wholesale orders. You want one table so you can build a single report. In Power BI, that’s called appending: stacking the rows of one table under another. In this guide, you’ll learn how to append tables in Power BI using Power Query’s … Read more >>>
A regional manager once looked at a report I’d built and asked, quite reasonably, where the North region had gone. The table of sales by region listed nine regions, but the company had twelve. Nothing was broken: North, along with two other regions, simply hadn’t sold anything that quarter, and Power BI leaves out groups … Read more >>>
If your DAX time intelligence formulas, such as TOTALYTD, SAMEPERIODLASTYEAR, or DATEADD, return blanks or incorrect values, a missing or poorly configured date table is almost always the cause. I’ve seen this trip up analysts at every level, from beginners building their first sales report to experienced modelers working with complex multi-table models. In this … Read more >>>
A client asked me to clean up a Power BI matrix: they wanted the subtotals gone but the column grand total kept. If you’re wondering how to turn off the grand total in a Power BI matrix, or keep it and hide only the subtotals, it comes down to two settings in the Format pane. … Read more >>>
122 copy-paste formulas with real examples, sent straight to your inbox.
Your free Power Automate Expressions Cheat Sheet is on its way. Can't find it in a few minutes? Look in your Promotions or Spam folder.
Sent to
