computaz

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this article, we explain the reasons why

Hi,  I need help to understand this error message (above image) and how to fix it, thanks

When you apply a filter or slicer to a PivotChart the custom formatting can change with each change in the filter. Here's what you can do about it.

Power Query doesn't require it's Excel source data to be strictly in a table any more. Let's look at pulling Excel named ranges into Power Query.

Running totals in Power Query can be fast, if you know how. This video shows different methods and analyzes why some perform better than others. WRITTEN ARTICLE: https://gorilla.bi/power-query/running-total/ Master Functions and Syntax in M https://powerquery.how ABOUT BI Gorilla: BI Gorilla shares videos and articles on Power BI and Excel to help you improve your skills. CONTENTS 00:00 Introduction 01:27 List.FirstN 05:02 List.Range 06:06 Performance Problems 10:47 List.Generate 17:33 Combine Running Total with Table 23:41 List.Accumulate Website: https://gorilla.bi SUBSCRIBE TO MY CHANNEL https://youtube.com/bigorilla?sub_confirmation=1 LET'S CONNECT: Blog: https://gorilla.bi Facebook: https://facebook.com/BIGorilla/ Twitter: https://twitter.com/rickmaurinus LinkedIn: https://linkedin.com/in/rickmaurinus/ Thank you for your support! #RunningTotal #powerquery #bigorilla

Hi,   Please can you tell me how to calculate the standard deviation of a calculated measure? I can only find examples that use calculated columns, not calculated measures. Is it even possible?   I need to find the standard deviation in transaction values ($). I have a calculated measure called "Tot...

When you think you pick an easy one...   In my recent quest to create or catalog as many DAX equivalents for Excel functions, I figured this one would be a cinch. Well, not so much. Between poor documentation and vexing issues with DAX not having any kind of inherent sort for data, I very nearly pul...

How to manage the LINESTX function results in DAX to compute linear regression. Article and download: https://sql.bi/800442?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt

This video shows how to create an index column for each category in your table. Within each category the number then starts from 1 and increases sequentially...

The ICANN registration data lookup tool gives you the ability to look up the current registration data for domain names and Internet number resources.

Learn how to fix the DNS_PROBE_FINISHED_NXDOMAIN error: 1. Flush DNS cache 2. Renew Your IP 3. Change DNS servers 4. Check the host file + more.

Want a running total that resets for different categories? This video shows how you can create grouped running totals. WRITTEN ARTICLEhttps://gorilla.bi/powe...

Learn how create virtual tables in Power BI using DAX. Reducing the number of tables and measures you need to create.

REMOVEFILTERS() is a new DAX function that was created to make the language easier to learn and understand. Learn why here!

"I like big aggregations and I cannot lie You other PBI'ers can't deny"   The attached PBIX file contains a slew of aggregations that span multiple columns All standard quick aggregations are included, namely: Max Min Sum Average Count Count (Distinct) Variance Standard Deviation Median   This te...

Returns all the rows in a table except for those rows that are affected by the specified column filters.

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might displ

Introducing Power BI's BRAND NEW function: OFFSET in DAX. While it officially not released just yet (september 2022), you can already use it! OFFSET enables ...

Leading zeros help when you need a fixed value length. Yet, theycan also help when sorting text values that include numbers. This post ...

If you want to create a row-number statically as a pre-calculation in Power BI, then Power Query has a very simple way of doing it; Add Index Column. However, the Index column creates the row number regardless of any grouping or categorization. sometimes you want to take that into account too. There is a little…

UPDATE 2019-10-18 Because of a bug in YEARFRAC function described in the original blog post and reported by Dominik Petri (thanks!), there are cases where t

In this video I show you how a technique that helps me a lot when I write my time intelligence measures in Power BI. Enjoy the video and subscribe for more v...

Learn how to effectively use the ALL and REMOVEFILTERS DAX functions in Power BI for creating powerful measures and calculated columns. Master these filter functions for better analytical solutions.

Recently I had an interesting use case where I had to a compound calculation in Power BI. You can compound an interest rate for example, where you get a certain rate on your savings. Let's say 1% (which is at the time of writing ridiculously high, but bear with me). After 1 year, you get 1% interest

@libreoffice-tdforg Todays video is about one of the most powerful and useful forecast functions i.e. Exponential Triple Smoothin (ETS) to predict the future...

This article describes how to write efficient DAX expressions that compute the compound interest of incremental investments made throughout the holding peri

Power BI time intelligence analysis is made simple by the Data Bear team through DAX SAMEPERIODLASTYEAR, PARALELLPERIOD and DATEADD functions.

I am working on Loss Triangle in Power BI where AccidentYear are rows and DevYear are columns. The values in the table are Running Total created by measure: Running Total Loss = CALCULATE...