Sharing my Power BI DAX for Annual Lifecycle and Giving Level Analysis
Annual_Lifecycle_and_GivingLevel_CalculatedTable.zip
Description:
This sample workbook includes a DAX pattern for a calculated table called Donor Summary, which summarizes constituent behavior by fiscal year for the purpose of lifecycle and giving level analysis, including upgrade/downgrade and churn.
Learn how to use GENERATESERIES() and GENERATE() expressions to crossjoin Constituents with a specified number of fiscal years to automatically generate summaries covering your desired time periods without future maintenance/intervention.
Required connections:
None required. The .pbix file includes sample data from the Sky Developer Cohort.
Skill level: Intermediate
Configuration details: Detailed pdf included in .zip
Category: DAX
Lifecycle Analysis
Giving Level Analysis
Comments
-
@Mark Zigadlo , thank you for sharing this solution that you found with help from Claude AI! This post wouldn't be here without you. ?
3 -
Discussed March 2025 in Microsoft Power BI User Group - Blackbaud Community
0
Categories
- All Categories
- 6 Blackbaud Community Help
- 206 bbcon®
- 1.4K Blackbaud Altru®
- 394 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 1.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- 15 donorCentrics®
- 357 Blackbaud eTapestry®
- 2.5K Blackbaud Financial Edge NXT®
- 646 Blackbaud Grantmaking™
- 561 Blackbaud Education Management Solutions for Higher Education
- 3.2K Blackbaud Education Management Solutions for K-12 Schools
- 934 Blackbaud Luminate Online® and Blackbaud TeamRaiser®
- 84 JustGiving® from Blackbaud®
- 6.4K Blackbaud Raiser's Edge NXT®
- 3.6K SKY Developer
- 242 ResearchPoint™
- 117 Blackbaud Tuition Management™
- 165 Organizational Best Practices
- 238 The Tap (Just for Fun)
- 33 Blackbaud Community Challenges
- 28 PowerUp Challenges
- 3 (Open) Raiser's Edge NXT PowerUp Challenge: Product Update Briefing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports+
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Email Marketing
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Gift Management
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Event Management
- 3 (Closed) Raiser's Edge NXT PowerUp Challenge: Home Page
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Standard Reports
- 4 (Closed) Raiser's Edge NXT PowerUp Challenge: Query
- 777 Community News
- 2.9K Jobs Board
- 53 Blackbaud SKY® Reporting Announcements
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)