Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
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] ) )
Solved! Go to Solution.
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
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.