Create Bins in Power BI
Power BI Bins are useful to create a range of data. It helps us group data points to more clearly view, analyze and explore data and trends in our reports…
Power BI Relationship and Cross Filter Direction
In most database management systems, you only have a relationship and no direction for it but this is not so in power bi, in power bi, we both have to…
Reconciling Contents From Multiple Sheets Using VLOOKUP
When using VLOOKUP in Excel, sometimes you may end up with the ugly #N/A error. This happens when your formula can not find the lookup value on the first Lookup…
Data Model and Table Relationships for a Required Report
Assuming you were already done with the import and cleaning of your dataset in Power Query. You can then proceed to the Model Tab and build the relationship between the…
The Relationship Between DAX and Visualization in Power BI (Part 2)
In the previous lesson, we were able to use DAX to ascertain the Number of Staff born on a particular year which was then represented on a Matrix Visual where…
Power BI DAX AND Visualization to Meet Report Requirement
In this tutorial, we will be looking at how Power BI DAX and Visualization come handful in meeting report requirement for a business case scenario. As a Sales Analyst in…
How to Extract the First Word from Text in Microsoft Excel
When working on your data, you might come to a point where you need to learn how to extract the first word from a text string for proper data cleaning…
Join us at the Global Excel Summit 2021. Grab a ticket today!
Come join us and 30+ other presenters and enjoy 4 days (6-9 Feb 2021) of Excel goodness. Grab your ticket at https://globalexcelsummit.com/tickets/ And something special for you, you can get…
Microsoft Excel Formula: Counting Records That Meet Multiple Date Criteria
As a Microsoft Excel user you must have been faced with a task where you needed to count how many records you have in your dataset; that is easy. What…
Invitation to our special webinar session with the Excel Legend, Bill Jelen aka MrExcel
Happy new year! And we (UrBizEdge) have been lucky to get Bill Jelen (whom I consider the most popular Microsoft Excel legend) to be our special guest this coming Sunday.…