SEARCH
You are in browse mode. You must login to use MEMORY

   Log in to start


From course:

POWER BI [PI-300]

» Start this Course
(Practice similar questions for free)
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?Select only one answer. 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-bi



Answer:

Add a separate date dimension table. This answer is correct.


0 / 5  (0 ratings)

1 answer(s) in total

Author

da-bi
da-bi