There are a number of pre defined DAX time intelligence calculations that help you to get analytics over time, such as year to date, same period last year, and etc. However, there is no calculation for Week to Date built-in. I have found it quite a demand for some of businesses, as many of businesses Read more about Week to Date Calculation in Power BI with DAX[…]
Something that is currently missing in DAX is a native set of functions to perform Bitwise operations. These can be incredibly useful functions and one, in particular, is the ability to convert a base10 number to its binary format. Once you have the number in binary format, you can apply logical operations between numbers to Read more about Quick DAX : Convert number to binary (and back)[…]
Carrying on from my recent article on how to build a game of Blackjack using Power BI and DAX, this time I thought I would see if I could build a fully playable game of Sudoku. A big thanks to my good friend Tom Martins over at minceddata for giving me the idea. The end result Read more about Fun with DAX – Sudoku[…]
A not so obvious use of the recently added GENERATESERIES function to use it to generate time buckets. The more common use of this function is to generate series of numbers, but it works just as well with Time based data. Say you want to create a data table with rows that represent time periods. Read more about Quick DAX: Use GENERATESERIES to create Time buckets[…]
I started Power BI Helper with the intention to help to find issues in Power BI reports faster and easier. This tool over time became better and better. I’m excited now to let you know that the version 2.0 of this product is now available for everyone to use and enjoy. This version comes with Read more about Power BI Helper Version 2: Connection Types, Multiple PBI files, Relationship advise, and Not used tables[…]
I thought it might be fun to try something a little different with this blog and use a combination of bookmarks with a little DAX magic to come up with a game that plays a hand of Blackjack. Power BI and DAX are not the ideal engine to build a game of Blackjack with, but Read more about Fun with DAX – Blackjack Game[…]
Using DAX time intelligence functions for a while; you may ask this question from yourself that what is the difference between functions below; SamePeriodLastYear function vs using ParallelPeriod with Year parameter ParallelPeriod for a month vs DateAdd for a month ago and many other questions that lead to this final question: Which function should be Read more about DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question[…]
In the previous post, I explained a usage of bookmarks and buttons in Power BI, which was for clearing all slicers. Buttons and bookmarks are the gold combination in Power BI. You can do wide range of creative activities with this combination. In this post, I will show you some other usages of buttons and Read more about Bookmarks and Buttons: Making Power BI Charts Even More Interactive[…]
Using bookmarks for clearing all slicers in Power BI is not a a new function, I have been using it for many months, and advising many people to do it that way. However, I still get a lot of questions in my presentations about how to do that. That is why I ended up writing Read more about Clear All Slicers in Power BI; A Bookmark Story[…]
Implementing a Power BI solution is not just about developing reports, creating a data model, or using visuals. Power BI, like any other technologies, can be used in a correct, or incorrect way. Any technology can be used more effective if it harnesses the right architecture. A right architecture can be achieved after a requirement Read more about Power BI Architecture Guidelines[…]