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!

Ray_Minds's avatar
Ray_Minds
Solution Supplier
1 year ago

Hi Anonymous 

To create a measure that displays the Rate for the selected Year,you can follow these steps:
1).Ensure that your date table has a relationship with the table containing the Year and Rate columns.

2).Create a new measure in Power BI with the following DAX formula:

Selected Year Rate =
VAR SelectedYear = SELECTEDVALUE('DateTable'[Year])
RETURN
CALCULATE(
MAX('YourTableName'[Rate]),
'YourTableName'[Year] = SelectedYear
)

Note:- Make sure to replace 'YourTableName' with the actual name of your table and 'DateTable'
with the name of your date table.
You can now use this measure in a card visual.

If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you.