HI everyone,
I tried to sum the amount per today…
=Sum(SELECT(Totzag[amount],And( [_THISROW].[Order id] = [order id],Date(DATETIME)=TODAY())))
It won’t work, any ideas?
Thanks in advance
If DATETIME is one of your columns it needs to be in [ ] brackets
User | Count |
---|---|
43 | |
29 | |
24 | |
22 | |
13 |