Hello
I have a table with many columns that I would like to get sum for each column by chosing which column to sum.
I made another table with name filters and I put some columns data to be used as a filter on first table.
My question is , is it possible to use dynamic column name from other table in this expression
SUM(
SELECT(
First table[column name],
AND(
(EOMONTH(TODAY(),-1))<[Date],
(EOMONTH(TODAY(), 0) + 1)>[Date]
)
)
)
Nope you can't have dynamic column name. I have a data table where depending on a condition I have to pick a particular column. So my formula is loosly:
IFS(
[This]="abc", Select(SUM([Column A],TRUE))
[This]="xyz", Select(SUM([Column B],TRUE))
)
PITA, especially when theres 70 columns ๐ฎ
Simon@1minManager.com
User | Count |
---|---|
34 | |
31 | |
30 | |
18 | |
17 |