In last month’s Business Intelligence Summit, one of our speakers, Greg Deckler, presented about DAX counterculture wherein he talked about alternative uses on DAX. One of his key topics is all about the DAX function CALCULATE and why you should avoid using it especially if you’re new to DAX. In this tutorial, Greg is going to pick up on that discussion and delve into another Microsoft quick measure —Average Per Category.

***** Video Details *****
00:00 Introduction
01:54 The goal
02:07 Data model
02:55 Average per Category measure
06:00 Better Average per Category measure

***** Related Links *****
Better Average per Category – https://community.powerbi.com/t5/Quick-Measures-Gallery/Better-Average-per-Category/td-p/2758871
—

***** Continue reading “How To Get Better Average Per Category In DAX – Why You Should Not Use CALCULATE” →

The ALL function is particularly useful for removing filters and creating calculations on all the rows in a table. In this video, Sam shows how you can use the ALL function in Power BI with DAX with specific use cases.

***** Video Details *****
00:00 Introduction
01:05 Total sales of each customer
02:04 ALL sales
03:45 Replacing customer names with customer index
04:01 Referencing the entire table instead of column name
04:32 Percent of sales

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE Continue reading “How To Use The ALL Function In Power BI And DAX [2022 Update]” →

In this video, Gaelim is going to demonstrate how to do text analysis using Python to identify parts of speech in texts brought into Power BI

***** Video Details *****
00:00 Introduction
01:15 Source data
01:59 Filtered rows
02:20 Code
08:16 Data

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Continue reading “How To Do Text Analysis Using Python To Identify Parts Of Speech In Texts In Power BI” →

In this video, Melissa demonstrates how you can automatically remove all empty columns from a table in Power Query. Melissa’s approach will involve the standard Table.Profile M library function and its additional aggregates parameter to add a non-empty count column.

***** Video Details *****
00:00 Introduction
00:12 Sample query
01:36 Data set
02:13 Select columns
04:08 Add non-empty count column
09:07 Custom function

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://www.enterprisedna.co/power-bi-resources
FREE – 60 Continue reading “How To Automatically Remove All Empty Columns In Power Query” →

Error Bars help visualize any uncertainty present in your data. Uncertainty is an important aspect to data or any fields so it’s best not to shy away from it. In this tutorial, Federico shares a couple of tricks with the Error Bars and how you can use it specify upper and lower bounds to the values in your line chart and customize the way the uncertainty is visualized on your Power BI reports.

***** Video Details *****
00:00 Introduction
01:36 Format pane
01:55 Error Bars
03:43 Different applications of Error Bars

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – Continue reading “How To Utilize Error Bars In Power BI To Visualize Uncertainty In Your Data” →

In this tutorial, Sam demonstrates how to use DAX measures to work out the difference between calculated amounts this year versus last year. Get an intro into the concept of measure branching in DAX.

***** Video Details *****
00:24 Summing up revenue column
00:37 Total sales measure
01:46 Reviewing total sales information by date
02:34 Total sales last year
04:20 Difference between sales this year vs last year
05:42 Visualization of difference between sales this year vs last year

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX Continue reading “Calculate Difference This Year vs Last Year In Power BI With DAX [2022 Update]” →