When you place a date field into a Pivot Table, and if you are using the 2016 version of Excel you get a hierarchy. But you don't always get that when doing the same in PowerBI.
What is a Date Table? How would you use it? How can it help you calculate the fiscal year? This step-by-step tutorial shows you the benefits of using a date table in Power BI.
The process of Ranking, or assigning a number to a field based on the value is an old but useful one. This tutorial will show you how to use the RANKX function to rank your products by sales.
