Forum Discussion
Create measure using 2 columns
I am looking to create a measure to display the data in column 2 for the year in column 1. I need to use this measure in a card to filter with the date table year. Year is formated as a whole # and...
Hi Anonymous - I think you donyt have any relationship between rate and date table, follow the below
create a measure as :
Selected Year Rate =
VAR SelectedYear = SELECTEDVALUE('Date'[Year]) -- Year selected from Date table
RETURN
CALCULATE(
MAX('RateTable'[Rate]), -- Replace 'RateTable' with your actual table name
FILTER(
'RateTable',
'RateTable'[Year] = SelectedYear
)
)Let me know if this solution works for your scenario!
Hi Anonymous
Thanks for the reply from rajendraongole1 and Ray_Minds .
Anonymous , Does their methods solve your problem? If so, could you please mark their answer as solution? This will help more users who are facing the same or similar difficulties. Thank you!
Best Regards,
Yulia Xu