Forum Discussion
Calculated Table error with data refresh
This post is a follow up to a previous post but it's hard to get eyes on older posts with accepted solutions. I was able to create a calculated table using the below DAX, however, when I refreshed my...
Hi Anonymous ,
Please check if you have blank data in the Table1[Enrollment Date] column or exists some data of wrong format which cannot uses YEAR() function, you can try to use IF ISBLANK() to find this value.
Best Regards,
Teige
Did you change the name of your Table1 query? Seems that for some reason Beg and/or Fin are returning blank.
Greg_Deckler - nope, I did not change the name of the query or table or any of the column names.