Can somebody help me with virtual columns?
I have this appformula - =SUM(SELECT(Expenses[Value], Expenses[Category] = Categories[_THISROW]))
What I try to get is:
The SUM of each Value from a specific Category.
Verifying the formula gives me an all good status, but when I test it, it remains 0. Like it doesn’t make the calculations at all.
Any tips how to make such formula?