Measure that counts how many products had its price change between dates

mateus_luzzi — Tue, 22 Dec 2020 23:31:17 GMT

Hello, friends!

It's the second time I'm posting this, I lost 10 min writing a good question text and for some reason this forum kicked me out and I lost all my text. 😥

OK, let's go:

I'm comparing historical prices among several products, for pricing purposes.

I need a measure that counts how many products had it's price changed, between a date that an user will input (parameter) and the last price.

Let me give you an example:

The user chose a 30 day analysis and today is 12/22/2020.

Product	Store	Price Sold	Date	not part of table, just comment
Banana	Jhonny's Groceries	20	11/22/2020	30 day analysis refer to this date
*Apple*	*Paul's Groceries*	11	*11/22/2020*	30 day analysis refer to this date
*Apple*	*Jhonny's Groceries*	9	*11/22/2020*	30 day analysis refer to this date
Banana	Jhonny's Groceries	18	11/24/2020
Banana	Jhonny's Groceries	17	11/29/2020
...	...	...	...
*Apple*	*Carl's Groceries*	12	*12/19/2020*	last price entry for 'apple'
Banana	Jen's Groceries	15	12/20/2020	last price entry for 'banana'

So what is expected to happen:

Get the average price (because it's possible to have more than one record for a product in the same day) of X days earlier, in this case 30 days
Get the average of last price, something like that:

Last Avg Price = CALCULATE(AVERAGE(Sales[Price]),LASTDATE(Sales[Sale_Date]))

Count how many products price went up and how many went down
It might be a scalar, because I need to display this in a card

That's it!

Can somebody help me, please? Thank you!

Re: Measure that counts how many products had its price change between dates

amitchandak — Wed, 23 Dec 2020 03:49:35 GMT

mateus_luzzi , Try a measure like

countx(filter(summarize(Table, Table[Product],"_1", distinctcount(Table[Price Sold])), [_1]>1),[Product])

This will any product that has changed the price

or try like

countx(filter(summarize(Table, Table[Product],"_1", calculate(distinctcount(Table[Price Sold]), allexpcept(Table, Table[Product]))), [_1]>1),[Product])

Re: Measure that counts how many products had its price change between dates

mateus_luzzi — Wed, 23 Dec 2020 15:28:51 GMT

Hello, friend amitchandak

I really appreciate your time. Unfortunately it didn't work. Do you have any other suggestions?

topic Measure that counts how many products had its price change between dates in DAX Commands and Tips

Measure that counts how many products had its price change between dates

Re: Measure that counts how many products had its price change between dates

Re: Measure that counts how many products had its price change between dates