Forum Discussion
Change tracking between dates
Look at the below example. I have a basket of fruits and I update the fruits and the price everyday. One day I have 4 fruits and the next day I am missing the orrange. Prices are also different. ...
Hi,
Create a Calendar Table with a relationship from the Date column of your Data Table to the Date column of your Calendar Table. To your visual, drag the Date column from your Calendar Table and Fruit column from your Data Table. Write these measures
Total price = sum(data[price])
Total price on previous day = calculate([total price],previousday(calendar[date]))
Growth (%) = divide(([total price] - [Total price on previous day]),[Total price on previous day])
Hope this helps.