Last night I completed the #WorkoutWednesday challenge for Week 17 using Tableau. Having started to experiment with Microsoft Power BI, and joining up with some user groups, I thought I’d see how my skills were progressing in the newest tool.
Quickly I found I still needed a bit to learn, and the requisite Google (perhaps I should have used Bing) of how to do Level of Detail calculations in Power BI didn’t turn up useful answer. Power BI uses DAX (data analysis expressions) to calculate measures and columns. Initially I just knew there had to be a way, there were way too many functions available to not be able to achieve this. In fact, I knew this was going to be easy, and again shock me at how great a product Power BI is, and had been right there all along, just waiting for me to pick it up and try my hand at it.