How to create a measure that only looks at 2019s data

[SRobbo1990]

Hi All,

I currently have a gauge to show how our company is doing against Previous Year, no problem. However they have also asked to look at current data against what we have in 2019 (As this was the last year with decent/full data). That's fine for the current year as i've done DATEADD, -2, year. However if the company look at 2020, this will show 2018s data rather than 2019. I want to do something like Calculate(Bookings, EnquiryDate contains 2019) but not sure on the DAX required or if its even possible

Thanks 

Sam 

[amitchandak · Accepted solution]

@SRobbo1990 , Try like

Calculate([Bookings],year([EnquiryDate])= 2019)

or

Calculate([Bookings],filter(all(Table[EnquiryDate]), year([EnquiryDate])= 2019))

or

Calculate([Bookings],filter(all(Table), year([EnquiryDate])= 2019))