Data Bear – Power BI Training and Consulting

Call us Today! (020) 8720 6880 | info@databear.com

Power BI Measures

Filters

Filters in Power BI: Everything You Need to Know

Power BI is a suite of business analytics tools that deliver insights throughout your organization. One of the most powerful features within Power BI is the ability to apply filters to your data, allowing you to analyze subsets of your data and focus on what’s most important. Understanding how filters work in Power BI can […]

Filters in Power BI: Everything You Need to Know Read More »

Mastering the Lookup value DAX function in Power BI

Mastering the LOOKUPVALUE DAX Function in Power BI

In today’s blog post, we will discuss the LOOKUPVALUE function: what it is, how to use it, and what you should consider before using this DAX function. What is the LOOKUPVALUE Function? The LOOKUPVALUE DAX function returns the value for the row that meets all criteria specified by one or more search conditions. In other

Mastering the LOOKUPVALUE DAX Function in Power BI Read More »

Power BI Desktop Update – April 2019

Power BI Desktop Update – April 2019 April has another exciting release for the Power BI Desktop Update. Power BI is really making sure that they continuously improve on the entire Power BI experience and functionality. The one very useful feature that was added in this months release is the conditional formatting for visual titles.

Power BI Desktop Update – April 2019 Read More »

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD

DAX Time Intelligence Functions In this blog post, we are going to look at three DAX time intelligent functions. These DAX time intelligent functions are PARALLELPERIOD, DATEADD and SAMEPERIODLASTYEAR. I know many of you will say the functions sound very similar and that they have more or less the same functionality. This is not the

Power BI DAX: SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD Read More »

CALENDAR TABLES WITH DAX

DAX CALENDAR & CALENDARAUTO In this blog, we’ll continue looking at more DAX ‘bear necessities’ and more specifically the CALENDAR tables with DAX. We focus on the DAX calendar functions namely CALENDAR and CALENDARAUTO. We will explain how these functions work and how you can use them to create date tables and therefore time intelligence reporting within Power BI.  If you prefer

CALENDAR TABLES WITH DAX Read More »

DAX RELATED TABLE FUNCTIONS

DAX RELATED and RELATEDTABLE Functions In this blog, we’ll be looking at DAX RELATED and RELATEDTABLE functions. If you prefer to watch the YouTube video, rather than reading the blog, please see the video below: RELATED DAX FUNCTION First, we will be looking at the RELATED function, which requires a column name as an input and returns a related value from

DAX RELATED TABLE FUNCTIONS Read More »

DAX TABLE FUNCTIONS PART 2 – VALUES, DISTINCT & ALLNOBLANKROW

DAX Table Functions (Part 2) In this blog post on the DAX ‘Data Bear’ necessities, we will build on our DAX table functions from part 1. This is the second part of our table functions series. In the first part of our two-part table functions series, we looked at the ALL and FILTER functions and

DAX TABLE FUNCTIONS PART 2 – VALUES, DISTINCT & ALLNOBLANKROW Read More »

DAX TABLE FUNCTIONS PART 1 – DAX FILTER & ALL

DAX Table Functions In this blog, we’ll continue looking at more DAX ‘bear necessities’ with a focus on the DAX table functions. Today we are looking at the most used table functions in a two-part blog series. So be sure to check out both of these blog posts to get a grip on these table functions.  In

DAX TABLE FUNCTIONS PART 1 – DAX FILTER & ALL Read More »