Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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...
Need Help
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    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

TeigeGao's avatar
TeigeGao
Icon for Solution Sage rankSolution Sage
7 years ago

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