Hi @newtopbi. More progress, but not an exact match. To ensure I didn’t use any previous assumptions, I rebuilt the PBIX from scratch, and with @Melissa’s help on the v4 DAX formulae, I’ve come quite close.
I’ve highlighted the matched values (exact or very close) in light blue. (There’s an issue [probably
small one, but I couldn’t find it quickly] with using the same base code for [Exited Balance] as for [Exited Members], but the technique works for “New”, so …)
I’m thinking that the differences between the Excel sample and the PBIX file may be Excel-calculation and data-related, and I didn’t dive into them deeper.
Hopefully this helps you get past the finish line.
Greg
eDNA Forum - Count of New & Exited Members by Channel FYTD v4.pbix (2.7 MB)