If statement with year

Hi rokas147 

Do you want to build a calculated column or a measure?

If you want to build a measure, use max function to get the Year value in '2018-2019-2020_data'.

If you want to build a calculated column, you use values from different tables. In which table do you want to build this calculated table, 'Case Study discount' or '2018-2019-2020_data'. If you want to build a calculated column in 'Case Study discount', you can't use Case studies and Year in '2018-2019-2020_data' directly, try to use related function to get the value.

You may refer to this blog for more details: Dax Error

If this reply still couldn't help you solve your problem, please share a sample with me by your Onedrive for Business.

And show a the result you want by screenshot. This will make it easier for me to understand your requirement.

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.