Question:
You have a fact table that contains sales data. The fact table includes a SalesDate column formatted as a Date data type. Auto date/time setting is disabled in both global and current file options. You load the fact table into Power BI Desktop. You need to ensure that you are able to analyze data on a yearly, quarterly, monthly, weekly, and daily basis. Your solution must minimize the model size and administrative effort. What should you do? Add a separate date dimension table. Add a year, month, and week columns to the fact table. Enable the Auto date/time current file option. Enable the Auto date/time global option.
Author: da-biAnswer:
Add a separate date dimension table. This answer is correct.
0 / 5 Â (0 ratings)
1 answer(s) in total