With getting 2018 wrapped up, I would like to thank you all for visiting our blogs and giving us your most valuable feedback. Here in this post, I’ll point out some of the most viewed articles we have shared and links to our books. 2018 was a year for me that I did moderate on writing Read more about Top 10 RADACAD Blog Posts of 2018[…]
All source files for this article can be downloaded here : A good friend and member of my local Power BI User Group contacted me recently to ask if I might help with a problem he trying to solve in DAX. He was keen to track the value of items purchased over time in chronological Read more about DAX : Inventory or Stock Valuation using FIFO[…]
Intro: In my younger days, I enjoyed playing computer games and in particular, maze-based games. So for the latest addition to my series of DAX based games, I thought I would have a crack at building a game in Power BI that allowed the user to appear to control a character through a maze to Read more about Fun with DAX – A-Maze-ing DAX[…]
You read it right, you don’t have to write DAX. If you are calculating a year to date, running total, or every rolling average, you may be able to do it without writing a single line of DAX code. How this is possible? With Quick Measures. Quick measures are an easy way to create DAX Read more about Quick Measures in Power BI: You don’t have to write DAX!?[…]
Sum and Sumx are functions that often founded to be misleading for many Power BI users. As both functions are doing the aggregation, it seems a bit confusing what is the actual difference between these two. There are many blog posts and articles about each function. I always explain the difference with simple demos in Read more about SUM vs SUMX; What is the Difference of the two DAX Functions in Power BI?[…]
In a Power BI model, relationships are important for passing filters, filter propagates through relationships. However, sometimes you create the relationship between two tables, and the relationship is a dashed line. In this post, I’ll explain to you everything you need to know about a dashed relationship, or as it called Inactive relationship. I will Read more about UseRelationship or Role-Playing Dimension; Dealing with Inactive Relationships in Power BI[…]
Here is a technique you might consider if you need to split text down to individual words. This could be used to help count, rank or otherwise aggregate the words in some longer text. The approach detailed here uses spaces as a delimiter and will not be tripped up if multiple spaces are used between Read more about Quick DAX : Word count[…]
The latest addition to my recent series of DAX based games is the classic Minesweeper game. This is the game where you are presented with a 9 x 9 matrix of squares. There are 10 hidden mines and you can either step on a square or place a flag where you think there might be Read more about Fun with DAX – Minesweeper[…]
There are many time intelligence functions in DAX, and each of those is helping in aspects of analyzing data on dates. There are two functions which work very similar to each other but have a bit different usage; DatesInPeriod, and DatesBetween. In this post, I will show you what is the difference between these two Read more about DatesInPeriod vs DatesBetween; DAX Time Intelligence for Power BI[…]
To follow in the spirit of some of my recent blogs, I thought I would have a look to see how feasible it might be to build a Tic Tac Toe game using just DAX and Power BI. I get pretty close and will detail my approach here in this article. For starters, here is Read more about Fun with DAX – Tic Tac Toe[…]