Charley
Member
- Joined
- Jul 29, 2017
- Messages
- 64
- Reaction score
- 0
- Points
- 6
- Excel Version(s)
- 365
What's the best strategy for managing a dynamic calendar for DAX, as defined by Power Query?
We could keep it in the Data Model, in a worksheet linked to its Data Model, in a CSV file, in a separate workbook from which Power Query could import the table's data, or probably in several other configurations.
Which approach seems to work best? And why?
We could keep it in the Data Model, in a worksheet linked to its Data Model, in a CSV file, in a separate workbook from which Power Query could import the table's data, or probably in several other configurations.
Which approach seems to work best? And why?