How to use RANKX in DAX (Part 2 of 3 – Calculated Measures) When I first started to play with DAX, one of the functions that seemed to confuse me more than it should, was how to add ranking to my data. It didn’t seem to matter what the data was, if I followed the Read more about How to use RANKX in DAX (Part 1 of 3 – Calculated Columns)[…]
I normally post about machine learning topics. this post is mainly about the conference that we organized in February 2018. What is Difinity Difinity Name: Data +Infinity Difinity Location: Auckland, New Zealand When normally Happen: February Difinity Conference: Is a Microsoft Data Platform Conference in New Zealand, Auckland that has been held in 2017 Read more about Difinity Conference[…]
Business Understanding Business understanding is the main and first step for doing machine learning in any platform or languages. Not all business problem can be addressed by machine learning approaches. There are some proposed categories for machine learning such as “Supervised Learning” and “Un-Supervised Learning”. Supervised Learning is about when we identify both input and Read more about Business Understanding for Machine Learning – Descriptive Analysis[…]
Power BI leverages a very powerful method of sharing named Power BI Embedded. This method of sharing is important because of mainly two specific features of it. With this method, you can share Power BI content in your custom application, and you can share it with your custom application users, regardless if they have Power Read more about Power BI Embedded; Power BI in a Custom Application[…]
One of the great features of Power BI Desktop is the ability to import your entire Power Pivot Excel model into it. This is an awesome feature, because you can import the entire model including tables, relationships, calculations, and hierarchies into the Power BI. This is a great migration feature from Excel to Power BI. Read more about Power BI Issue Fix: Import from Excel Workbook Contents; Password Protection Failure[…]
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 about Unleash Security Patterns in Power BI; Webinar Recording and Materials[…]
Ever wanted to create a diagram of your MS SQL Database tables in Power BI? Here is what I did to make that happen. The approach is to build a query that can be run against the catalog system views inside each MS SQL database. The approach is to build a list of “From” and Read more about Diagram your Database Tables using Power BI[…]
Previous versions of Power BI Helper had some features related to the visualization part and the modelling part of a Power BI file. This latest release of Power BI helper, can export the entire M or Power Query script into a file or into clipboard. Sometimes, especially when the number of queries in the Power Read more about Export the Entire M Power Query Script from a Power BI File, New Version of Power BI Helper, Search based on Field Description in the Model[…]
In the last post, I have explained how we can create a function with the aim of parametrising the machine learning process. In this post, I am going to explain how we able to create a Development and Production environment. Create Different Environment in Power Query to create a new environment, In power query, I Read more about Creating Machine learning Development and Production Environment in Power BI-Part2[…]
A recent post on a community.powerbi.com forum asked if it was possible to show a slicer of months, and configure a report so when a user selects a single month from the slicer, visuals will show data for a date range relative to that selection e.g. the preceding 10 months of data. If a user Read more about Dynamic Date Range from Slicer[…]