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 have a Calendar table and from this table we show a filter with the different years that can be selected.
When you select a year, I'm trying to retrieve it with SELECTEDVALUE(Calendar[Date]. [Year],MAX(CALENDAR[year])), but in the virtual table does not retrieve any value for the year
I do not know if the virtual tables can not use values that come from some filter