Forum Discussion
Custom date table
I have created a custom date table and started creating the appropriated hierarchy. However, I need to get the selected value of the year, but the measure only allows to select the date field, not t...
some1else there shouldn't be a problem selecting the year column from a custom calendar. It's just like any other column in any other table. Can you share more info about what you don't succeed. Better to also share a link to download a sample PBIX so I could take a look at your scenario.
Left image: "Date Hierarchy" is based on the "Date". "Ano" was added to the hierarchy.
Right image: the measure. Whatever year I select on the slicer (based on "Ano"), every other visual filters accordingly, but the measure always calculate as -1 or Blank.
