Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

DAX Retrieve Year Value in a Virtual Table

Hello everyone I have a table with values to display in a Segmenter and another table with target values. Depending on the selected year, only the values q appear in the T_Objetiv...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

I think the most logical thing would be that if we do not have a selected year we take the biggest
SELECTEDVALUE(Calendar[Date]. [Year],MAX(CALENDAR[year]))

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

    Then do that.  MAX() is a good stand-in for SELECTEDVALUE() especially when the expected Total is also the last value.