Is a transaction date within 12 calendar months from a set date (boolean)

[AnttiKoskinen]

Hi!

I can't wrap my head around this one but I know the community can.

I have fact table with transactions and dim calendar which is connected to fact via date.

factdim calendar

I'd need a boolean in fact table which gives 1 if Data_transaction is within 12 calendar months from Reporting Date (images are illustrations of what I'd need, unfortunately not the tables I've managed to produce).

Could you help me out with a solution which solves this?

[lbendlin · Accepted solution]

=IF([Date_Transaction]>EDATE([Reporting Date],-12) && [Date_Transaction]<=[Reporting Date],1,0)

= IF([Date_Transaction] IN CALENDAR(EDATE([Reporting Date],-12)+1,[Reporting Date]),1,0)

[AnttiKoskinen]

Fantastic! Thanks!