Forum Discussion

garrettw's avatar
garrettw
Frequent Visitor
5 years ago
Solved

Calculated column in Calculated table only populates first 430ish rows. Help?

Hi All,   I'm having a very odd issue with Power BI.    I have a calculated date table created with the CALENDAR function to handle a range of dates. I then have a calculated field "Fiscal Year" ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi garrettw ,

     

    The problem is with the DATEADD() function. The column will be blank value when the calculated date is greater than the maximum date in the table.

    You could use EDATE() function instead.

    Fiscal Year = YEAR(EDATE('date table'[Date],'date table'[fiscal offset]))

     

    Best Regards,

    Jay

garrettw's avatar
garrettw
Frequent Visitor
5 years ago

Thanks for the link -- lot of good information in there that I might use going forward, but in this case I need to create the table with the offset calculations for another reason (This client also has to provide reporting for their clients' fiscal years, so I have to generate the fiscal calendar data on the fly based on other data) -- so I don't think that will quite apply.

I don't think this issue is just limited to fiscal calendars -- it seems PowerBI is just decided at row 430 or so, "I'm just not going to do these calculations for any more rows". This is a table that will have other calculations in it so I need to figure out what I'm doing wrong or if this is a bug of some sort.

Thanks in any case, lots of good stuff in your blog post that will help me with other aspects of the reporting for them!