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.