Forum Discussion
Solved
Total Sales Payment
Hi Everyone... I have a total of sales and I have a reference table with the range to calculate the payment for total sales. I use this calculated formula, but I think is no the best way, and I wan...
- This should give you what you are looking for...Lookup_Value = CALCULATE( VALUES( 'Table (5)'[Value] ), FILTER('Table (5)', 'Table (6)'[Sales#] >= 'Table (5)'[From] && 'Table (6)'[Sales#] <= 'Table (5)'[To]))
This should give you what you are looking for...
Lookup_Value = CALCULATE( VALUES( 'Table (5)'[Value] ), FILTER('Table (5)', 'Table (6)'[Sales#] >= 'Table (5)'[From] && 'Table (6)'[Sales#] <= 'Table (5)'[To]))
may not mention it, Sale# come from a count. The original data is SaleName and a DATE of the Sales.
With you calculate formula I don't have a Total at the end of the column.
