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 UserWhat is your initial data ? and what is your expected output ?
My raw data look like this
I can easly transform it like that
*those are regular year they are financial year (april to march)
At end and I need this table
- AmiraBedh
How 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-qfzDQsNote:
1) you can ignore [GDI]="TGDI" and treat it as a 1=1
2) FYY = Fiscal Year