Power BI - Gift Status Date not available for Power BI

Rijusiddha Drewett

Hi there. I am looking for a bit of advice. I have connected Power BI to NXT to run some figures for new Regular Giving Gifts year on year (and by month and quarter) and also the same cancelled or terminated gift. However the only way to tell when a Direct Debit was stopped is by the status and the status date. Status is in the gift tables but Status date is not making it impossible to provide the correct metrics.

Am I missing something or is it stored under a differently named field than is obvious? Most of the time the gift modified date ties up with the status date I see on RE but if something else has been modified on the gift after the status changed and saved I am assuming that date will be updated and is therefore not relevant to what I need.

I can also see some columns ‘gift.recurringstatusdateyear, gift.recurringstatusdatemonth and giftrecurringstatusdateday’ but these are all blank despite status dates being shown on the record.

Any advice please. Thanks