Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |