Forum Discussion

Rocky_Brown's avatar
Rocky_Brown
Helper I
3 years ago
Solved

Dax Help

I am creating a Dates Table that give me Good Friday dates to use in filtering my data.  I go into Modeling > New Table and create the following:   Years = Values('Date'Date.[Year]) I get the foll...
  • bolfri's avatar
    3 years ago
    Years = CALCULATETABLE(VALUES('Date'[Date].[Year]);NOT(ISBLANK('Date'[Date].[Year])))

    You can filter out the blank values.