Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. 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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
147 | |
72 | |
63 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |