Two date dimensions

[Olek]

Hi,
I have issue with setting two date dimensions in dashboard.
The goal I want to achieve is to have a history of records, which are also have it's own date dimension. You can download model and dashboard. I would like to have difference in growth ower selected period for defined dates.

For example 2 days ago I sold a car for 1000, and yesterday the proce have changed to 1500. The sale date is for today. So the growth over 2 days is 1500, and for 1 day 500.

Additionally i would like to compare those values to previous year, and go back with both date dimensions.

Tricky part is also, that if there is not sale for this year, PastYear() wont count prior year.

I tried to play around with filtered measure plugin, however it doesn't give me exactly what i want.

Do you have any suggestions how can I approach such data and 2 date dimensions?
Thanks 🙂

PriorTest.xlsx

model.json

dashboard.json

[DRay]

Hi @Olek,

Sorry for the delay in responding to this. With the holidays and everything I have quite a backlog to get through! 

This looks like a support request or a Help & How-To forum question. Have you already worked with someone to try and solve this?