Matt H on 13 Feb 2020 09:10:56
Background: while coding DAX functions I find myself writing temporary table statements using FILTER () /ADDCOLUMNS () /etc. quite often. I store these in variables to use later in a measure with an iterator function. A fair amount of measures share the same temporary table, for example running statistics (AVERAGEX/MEDIANX/STDEVX)
IDEA: develop the ability save temporary tables, like you would save measures, so you could have a one-stop-shop for updating/debugging etc. to improve maintenance time. Essentially you'd be saving a script that you can use to drive multiple measures in a report