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 last Post, I have explained some parts of creating Custom visual such as how to create an icon, name of visual, and the how-to allocates fields to a custom visual. There are some other settings that need to be set up beforehand as well. the number of data fields you able to pass to Read more about Create Custom Visual with R and JSON- Part 4[…]
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[…]
A recent post on the Power BI community website asked if it was possible to compress a group of numbers into text that described the sequential ranges contained within the numbers. This might be a group of values such as 1, 2, 3, 4, 7, 8, 9, 12, 13: (note there are gaps) with the Read more about Fun with DAX – Compressing Numeric Sequences to Text[…]
In this post, I am going to show you how we can create most comprehensive Custom visual. In the last two posts published in July 2017 (post1 and Post 2). Some notes before I am going to complete the last two posts. 1- We able to declare some custom input like X, Y, Legen and Read more about Create Custom Visual with R and JSON- Part3[…]
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[…]
I normally work with most of the Microsoft tools for the aim of doing machine learning. I came up with a roadmap that shows what option for machine learning we have with Microsoft tools in Data Platform. this roadmap is not completed yet, I need to update it one later with some tools such azure Read more about Road Map to use Microsoft ML tools[…]