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…