topic Re: A Dax Measure that calculates the change in price in DAX Commands and Tips

A Dax Measure that calculates the change in price

Idang — Mon, 14 Nov 2022 14:35:01 GMT

Hi all,

I am trying to create a Measure in DAX that calculates the change in price for the 3 products below from the beginning of the year till today and for each customer.

I’ll show the result within a matrix visual.

Thanks 🙂

Re: A Dax Measure that calculates the change in price

Anonymous — Mon, 14 Nov 2022 15:57:07 GMT

hello Idang ,
this is confusing i didnt really understand what you want can you please explain more? are the dates the same date for each customer and prodcut key? what is it you are trying to acheive. thank you

Re: A Dax Measure that calculates the change in price

Idang — Mon, 14 Nov 2022 17:12:02 GMT

Hi Anonymous

Thanks for replaying,

The dates are the same date for each customer and product key.

What I'm trying to achieve is to show the change in price for each product YTD, QTD & MTD

You are right I showed a misleading price table please see below the amended:

The end goal would be:

Thanks,