Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    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!

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

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!