Tag: DATEADD Function

CALCULATE Function – How It Can Affect Your Calculations On Power BI

In this tutorial, I want to show you what the CALCULATE function can do through a few examples. CALCULATE is one of the most frequently used functions in Power BI. It dictates the context being applied to any measure and removes any existing filters in place. Using CALCULATE Function For Total Sales To truly understand

Continue reading

Time Comparisons In Power BI: This Year vs Last Year

Time Comparisons In Power BI: This Year vs Last Year

I want to go over how you can easily do time comparisons in Power BI and specifically calculate this year versus last year. I’m going to show you a couple of techniques that you can utilize for time comparisons like this. You can watch the full video of this tutorial at the bottom of this

Continue reading

Use Tabular Editor To Create Calculation Groups In Power BI

Use Tabular Editor To Create Calculation Groups In Power BI

Today’s blog post will give you an introduction to calculation groups. I’ll try to answer four basic questions regarding calculation groups and the Tabular Editor. You can watch the full video of this tutorial at the bottom of this blog. Calculation groups are a collection of items, and collection items are basically the same measures

Continue reading

Ranking Visualization In Power BI – Dynamic Visual

In this blog post, I want to teach you how to show your customers moving through groups over time in a dynamic way. You can do this ranking visualization in Power BI using a unique slicer. You may watch the full video of this tutorial at the bottom of this blog. When I click This

Continue reading

TOPN DAX To Showcase Top Customers This Period vs Last Period

TOPN DAX To Showcase Top Customers This Period vs Last Period

In today’s post, I want to show you a unique way of using the TOPN DAX ranking function to showcase your top clients over multiple periods. You can also watch the accompanying Power BI tutorial video below this post for more help. You may watch the full video of this tutorial at the bottom of

Continue reading