How to pass table name dynamically in DAX formula

Asked Jan 07 '21 at 06:30

Active Jan 07 '21 at 15:57

Viewed 146 times

I would like to call the table name dynamically from a different table. But the DAX formula I used below is not really catering to my needs. Anyone can help me with this, please?

m-AvgVolume % = 
VAR tableName = 
    SELECTEDVALUE(gnr_projects[TableName])
RETURN 
    SUM(tableName[Volume])

edited Jan 07 '21 at 15:57

Alexis Olson

38,724
7
42
64

asked Jan 07 '21 at 06:30

user3440676

It's not possible. – sergiom Jan 07 '21 at 08:50
Probably not possible directly, but you could set up a SWITCH function to handle all the possible cases. – Alexis Olson Jan 07 '21 at 15:59

How to pass table name dynamically in DAX formula

0 Answers0