I want to get the last low value in a table, but i can't. It only get the low value this year. Any one can help me please?
I'm using this expresion now
MINROW("Table",
"Column", AND(
([element] = [_THISROW].[name]),
([date] >= DATE("1/1/" & YEAR(TODAY())))
)
)
@chocolate wrote:the last low value in a table
It's unclear what you mean by this.
Did you try either of the following? Does one of these return the value you need?
MINROW("Table", "Column", [element] = [_THISROW].[name])
MIN(Table[Column])
If you need more assistance, you should post screenshots of your table's list of columns and an explanation of what value you want to return from which column and where in your app you need to return that value.
Whenever I see things like this:
... it's typically because there's a missing reference connection
- or it's there, it's just not being used for whatever reason.
If you connect things together with references, then you get a reverse reference on the parent level - this, contains all the related records.
index(
[Related Whatevers][Item],
count([Related Whatevers][Item])
)
User | Count |
---|---|
17 | |
12 | |
9 | |
4 | |
4 |