Data Bear

Call us Today! (020) 8720 6880 | info@databear.com
DataBear
Power BI Training
Contact Us

Power BI Measures

Power BI update

Mastering Grouping in Power BI: 5 Powerful DAX Measures You Need to Know

Power BI Measures /

In this post, we’ll delve into the powerful capabilities of grouping in Power BI visuals using various DAX measures. By exploring functions such as ALL, ALLSELECTED, ALLEXCEPT, and REMOVEFILTER, you’ll learn how to efficiently manage and manipulate your data for better insights. Grouping in Power BI is a crucial skill that can enhance your data

Mastering Grouping in Power BI: 5 Powerful DAX Measures You Need to Know Read More »

Filters

Filters in Power BI: Everything You Need to Know

Power BI DAX, Power BI Measures, Power BI Tips /

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

Microsoft Power BI, Power BI, Power BI DAX, Power BI Measures /

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

Microsoft Power BI, Power BI Desktop Updates, Power BI Measures, Power BI reports /

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

Microsoft Power BI, Power BI DAX, Power BI Measures, Uncategorized /

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

Data Bear, Power BI, Power BI DAX, Power BI Measures /

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

Data Bear, Microsoft Power BI, Power BI DAX, Power BI Measures, Power BI Tips, Uncategorized /

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

Microsoft Power BI, Power BI DAX, Power BI Measures /

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 »