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 data it caused an error that says "The arguments in GenerateSeries function cannot be blank." Since small tweaks to the dataset were done (nothing changed in the referenced columns) I tried deleting the original table and re-created the table but I am still getting the same error. Any ideas?
Calculated Table =
GENERATE (
Table1,
VAR Beg =
YEAR ( Table1[Enrollment Date] )
VAR Fin =
IF (
ISBLANK ( YEAR ( Table1[Exit Date] ) ),
YEAR ( TODAY () ),
YEAR ( Table1[Exit Date] )
)
RETURN
SELECTCOLUMNS ( GENERATESERIES ( Beg, Fin ), "Service Year", [Value] )
)
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
3 Replies
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.
