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
Watch video 61 - Using a calculated table as a list of eg definitions online without registration, duration hours minute second in high quality. This video was added by user WesleySon 21 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 24 once and liked it 0 people.