Forum Discussion
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...
Years = CALCULATETABLE(VALUES('Date'[Date].[Year]);NOT(ISBLANK('Date'[Date].[Year])))You can filter out the blank values.
Hi Rocky_Brown,
It could be happening because you have a blank row somewhere. Please check your date table and ensure that you have continous non null values.
Did I answer your question? Mark this post as a solution if I did!
Check out this blog of mine: How to Export Telemetry Data from Azure IoT Central into Power BI