Fun with DAX – Blackjack Game

Posted by on Jun 8, 2018 in DAX, Power BI | 3 Comments

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

DateAdd vs ParallelPeriod vs SamePeriodLastYear; DAX Time Intelligence Question

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

DAX : Convert Number into Month Name

Posted by on May 19, 2018 in DAX | 4 Comments

I sometimes see requests asking how to convert a number between 1 and 12 into a month name such as “Jan” or “February. The most common solution I see offered is along the lines of a SWITCH statement that lists 12 conditions (one for each month).   This works, but can also be done using existing ...

Read More

Unleash Security Patterns in Power BI; Webinar Recording and Materials

Thanks to all attendees of my Power BI webinar last Friday. I hope you all enjoyed it. I explained a number of the most common row level security patterns in Power BI with some DAX expressions, in this post you will find the description of webinar, recording, and link to all demos and materials. Although ...

Read More