This blog centers around a Power BI timesheet and the associated wage costs. I’m going to show you how to calculate time data and wage type using DAX. I’m going to demonstrate a DAX solution using measures and another one using calculated columns. You may watch the full video of this tutorial at the bottom
In this tutorial, you’re going to learn the complex measures and DAX formula used to create an inventory management dashboard in Power BI. As a seller, you have to know how many products you need to re-order and stock and how much these will cost you. Use these DAX formula patterns to get those calculations
In this tutorial I want to show you some samples of Advanced DAX calculations in Power BI. After going through the basics, I’ll now demonstrate some advanced functions and formulas that are key to computing more complicated calculations. I won’t cover every formula or function, but instead I’ll give you an overview of a few
You’ll learn in this tutorial how to calculate difference in days between purchases using DAX in Power BI. This topic came from the Enterprise DNA support forum and I’ll show you how I solved it. This is an interesting scenario and quite common in the business world. You may watch the full video of this
In this tutorial, I’m going to run through some advanced analytics techniques within Power BI and the DAX formula language that I call secondary table logic. You may watch the full video of this tutorial at the bottom of this blog. Sometimes when using Power BI for your analytics, you’ll want to find or discover
