61 - Using a calculated table as a list of eg definitions
This only works in Power BI, not Excel. You can't create calculated tables with DAX in Excel.
I show a trick where you can create a calculated table to store eg different statuses or months that need to be grouped together. This lets you reference it in multiple measures, and you only have to change your definitions in one place.
Kind of like using a table as a list/variable.
00:00 Rationale
01:36 Calculate, column IN Values()
02:04 Updating a definition