Tag: DATEADD Function

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 may 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 on calculation groups. I’ll try to answer four basic questions regarding calculation groups and Tabular Editor. You may 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 that

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

Time Intelligence DAX Functions In Power BI

For this tutorial, we’ll branch out to some examples of time intelligence calculations using a combination of DAX functions. This kind of calculation is useful when you want to compare your business data over a certain period. You can do it by days, months, quarters, or years. Aside from the CALCULATE function, using other DAX

Continue reading