Switch Function in PowerBI and MS Excel
Do you ever get frustrated when you have to nest multiple conditions using the IF function in Excel? If YES, you are not alone on the table. Let me introduce…
Custom Shape Map in Power BI
Introduction Maps are excellent chart choices for presenting geographic information as they overlay the numerical data on top of the geo-coordinates of the places. This makes the report user see…
The DAX and Power Query Way to Group By in Power BI
Today, I'll be sharing with you the amazing Group By feature in Power Query, and the DAX equivalent I typically use. I have a database of stocks on the Nigerian…
How To Automatically Pull In New Report Data Into Excel Using PowerQuery
One common situation most users of Excel face in making recurrent reports -- daily reports, weekly reports, monthly reports etc -- is that of updating the raw data part of…
Power BI #3: The Query Editor
When you launch the Power BI Desktop, the start up screen you get has Get Data on the top left side.The Get Data is the your first window into the…