Calculated Column "Item has been booked in the past 3 months"

[Anonymous]

Hello together, 

I am currently building a Sales report and facing a problem. 

I don't know how to create a column which shows, if the item has been booked in the last three months. 

There are two tables: 

• Projects
• Time_entries

Every project can be booked multiple times. 

Thank you in advance for your help!

[Natallia_23 · Accepted solution]

Hello,

I did such example, 2 projects and several dates: 

Booked = CALCULATE(MAXX('Date',IF(DATEDIFF('Date'[Date], NOW(), MONTH)<=3,1,0)), FILTER('Date', 'Date'[ID] = Project[ID]))