PowerBI has built-in date hierarchy features that seem to cause confusion in not only new users but experienced users. This article shows you how to avoid errors.
How to use Date vs Date Hierarchy in Power BI
How to Convert Excel Tables into Dimensional Fact Tables Using Query Editor
If you have an excel table that is built for data entry, it may not be in the best format for data analysis or your data model. By using Query Editor, you can keep the original table and create a version that you can use for analysis as a dimensional fact table.