Hello!
I'm new at powerpivot and i have a hard time resolving the following problem.
I have a table with the following columns
seller name
product name
sales period (month)
number sold
Sales amount
I want to make a measure that answers for this question: The last period my seller sold the product X, how much was the sales price?
I tried a number of ways, but i dont get the filters right.
Last sold period= calculate(max('table[sales period]);'table'[product name]="X")
Sales amount for X last period= calculate(sum('table'[sales amount]); filter('table';'table'[sales period]='table'[Last sold period]);'table'[product name]="X")
In the last formula - something goes wrong. I understand that i cannot filter in the way that I do - but i dont know how to make it better. Any tips or suggestions?
Thank you!
I'm new at powerpivot and i have a hard time resolving the following problem.
I have a table with the following columns
seller name
product name
sales period (month)
number sold
Sales amount
I want to make a measure that answers for this question: The last period my seller sold the product X, how much was the sales price?
I tried a number of ways, but i dont get the filters right.
Last sold period= calculate(max('table[sales period]);'table'[product name]="X")
Sales amount for X last period= calculate(sum('table'[sales amount]); filter('table';'table'[sales period]='table'[Last sold period]);'table'[product name]="X")
In the last formula - something goes wrong. I understand that i cannot filter in the way that I do - but i dont know how to make it better. Any tips or suggestions?
Thank you!