Forum Discussion
Rocky_Brown
3 years agoHelper I
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...
- 3 years ago
Years = CALCULATETABLE(VALUES('Date'[Date].[Year]);NOT(ISBLANK('Date'[Date].[Year])))You can filter out the blank values.
bolfri
3 years agoSolution Sage
Years = CALCULATETABLE(VALUES('Date'[Date].[Year]);NOT(ISBLANK('Date'[Date].[Year])))You can filter out the blank values.
Rocky_Brown
3 years agoHelper I
Accepted