Forum Discussion
DAX table variables
For the last couple of weeks I`ve been trying to incorporate variables in DAX codes. However, I´ve struggled deepley when defining tables as variables. The main problem comes up when trying to refere...
AlexisOlson
Super User
Super UserYeah, it's an annoying limitation. However, there are workarounds.
For example, if you want to look up the [Promedio anual] for a given [Codigo], say, 123, then you can access it like this:
MAXX(
FILTER(Table_1, [Codigo] = 123),
[Promedio anual]
)There's only one row for that [Codigo], so the max will just be whatever is in that column.