Combine two similar values into one measure depending on the year

[Anonymous]

Hi guys,

I've got one table with the columns 'year' and 'price' and I use 'year' as the x-axis of my line diagram. For the years 2022 - 2025 I use the price values from the same table, but for the years 2020-2021 I have to use price values from another table. How can I express this issue in DAX?

Best regards

[lbendlin]

Use SELECTEDVALUE() or equivalent to sense where on the visual you are (in your case where on the x axis) and then calculate the measure value accordingly.