Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

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. 

 

PowerOuzo_0-1633691116195.png

 

There are two tables: 

 

  • Projects
  • Time_entries

Every project can be booked multiple times. 

 

Thank you in advance for your help!

 

1 ACCEPTED SOLUTION
Natallia_23
Resolver I
Resolver I

Hello,

I did such example, 2 projects and several dates: 

Natallia_23_0-1633693671455.png

Natallia_23_1-1633693716437.pngNatallia_23_2-1633693756474.png

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

 

View solution in original post

1 REPLY 1
Natallia_23
Resolver I
Resolver I

Hello,

I did such example, 2 projects and several dates: 

Natallia_23_0-1633693671455.png

Natallia_23_1-1633693716437.pngNatallia_23_2-1633693756474.png

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

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.