Forum Discussion
Donor vs potential donor
Hello dear community, I'm classing my donations in 3 category: New (the 1st one), Renew (if last transaction was within 2 years), Ancient (if last transactions was older than 2 years. I'm able...
AmiraBedh
Super User
Super UserHow do you create the Category table ?
I'm using a formula like this
= Table.AddColumn(Index, "RenGDI", each let
AllDataTable = [Count],
PreRowValue =
Table.AddColumn(
AllDataTable,"RenGDI",
each try
if [GDI]="TGDI" then null else
AllDataTable[FYY]{[Index]+1}=[FYY]+1
otherwise false
)
in
PreRowValue)
as seen on https://www.youtube.com/watch?v=IGF2-qfzDQs
Note:
1) you can ignore [GDI]="TGDI" and treat it as a 1=1
2) FYY = Fiscal Year