Power BI Connection

Phil Bell

Trying to locate data from Recurring gifts using Power BI Connector any ideas?

Viet Truong

@Phil Bell you can use Gift Table
Check to see if you have Gift Type Set Up with Recurring. If yes then create a new column and use Dax to get the transaction that is recurrent

Recurring = Switch( True(),

search("RecurringGift",Gift[type],,0) > 0, "True"

, "False"

)

Phil Bell

@Viet Truong
Hi Many thanks unfortunately its the data from the recurring gift I am after such as the frequency last gift etc/

Kind Regards

Phil