Forum Discussion
Need help with a formula
I need to create a formula that summarize numbers in table based on column text i decide. This is my table I want it to do this: accountNumber = 5520 summarize "amountInBaseCurrency" ...
Hi, let's see if this works:
Calculate(sum('Table'[amountInBaseCurrency]),FILTER('Table', 'Table'[accountNumber] = "5520"))