Forum Discussion
Helper IVOverall % Change to a selected Date
Helper IVHello Bendlin,
Here is a sample of the data.
| Date | Province | City | New Housing & Residential Type | Price Index Value |
| 2017-01 | Alberta | Edmonton | House only | 100 |
| 2017-01 | Alberta | Edmonton | Land only | 100 |
| 2017-01 | Alberta | Edmonton | Condo Only | 100.2 |
| 2017-04 | Alberta | Edmonton | House only | 100.2 |
| 2017-04 | Alberta | Edmonton | Land only | 99.4 |
| 2017-04 | Alberta | Edmonton | Condo Only | 100.4 |
| 2017-07 | Alberta | Edmonton | House only | 99.8 |
| 2017-07 | Alberta | Edmonton | Land only | 99.9 |
| 2017-07 | Alberta | Edmonton | Condo Only | 100.1 |
| 2017-10 | Alberta | Edmonton | House only | 99.7 |
| 2017-10 | Alberta | Edmonton | Land only | 100 |
| 2017-10 | Alberta | Edmonton | Condo Only | 99.3 |
| 2018-01 | Alberta | Edmonton | House only | 99.7 |
| 2018-01 | Alberta | Edmonton | Land only | 100.1 |
| 2018-01 | Alberta | Edmonton | Condo Only | 98.6 |
| 2018-04 | Alberta | Edmonton | House only | 99.3 |
| 2018-04 | Alberta | Edmonton | Land only | 100.2 |
| 2018-04 | Alberta | Edmonton | Condo Only | 97.9 |
| 2018-07 | Alberta | Edmonton | House only | 99.5 |
| 2018-07 | Alberta | Edmonton | Land only | 100.5 |
| 2018-07 | Alberta | Edmonton | Condo Only | 97.6 |
| 2018-10 | Alberta | Edmonton | House only | 99 |
| 2018-10 | Alberta | Edmonton | Land only | 100.5 |
| 2018-10 | Alberta | Edmonton | Condo Only | 94.7 |
When I click on one part of the line, it will show me in the card above, the %change from 2017 to the date clicked on in the visual.
Hope I was able to explain it well. Would really appreciate your help on this.
Super User
see attached
- kalkhudary
Hello Bendlin,
I have tried this equation but did not yield the subraction that we need. I was looking what is the problem but seems it is not reading the min date value when we click on the visual.
When I cick on a particular point on the line visual, It is giving me the date, I clicked on and not 2017 the min date. In this condition, giving me the subraction as "0" and not for example 120 -100 = 20 as a numerator. Not sure what we need to adjust in the min date dax. The rest of equation is correct.
What do you think?
- lbendlin
That's an interesting issue. When you click on the datapoint you are now setting the filter context so that the min and max range is the same as the clicked value. That means you need to provide your desired min value from a different, disconnected table.