Forum Discussion

babajat's avatar
babajat
Frequent Visitor
3 years ago

Recover info from previous date event

Hi! So, i've got this data: Company 1 Company 2 Date InfoCompany 1 InfoCompany 2 My company xx 31/12/2022 6 11 My company gg 30/12/2022 4 22 ee aa 30/12/2022 4 7 My c...
Need Help
Sahir_Maharaj's avatar
Sahir_Maharaj
Super User
3 years ago

Hello babajat,

 

Can you please try this updated formula for 2ndPreviousInfo:

2ndPreviousInfo = 
VAR CompanyOI = 'Table'[Company 1]
VAR DateOI = EARLIER('Table'[2ndPreviousDate])
VAR FilterOI = FILTER('Table', ('Table'[Company 1] = CompanyOI || 'Table'[Company 2] = CompanyOI) && 'Table'[Date] = DateOI)
VAR _prev_date = MAXX(FilterOI, [Date])
RETURN MINX(FILTER(FilterOI, 'Table'[Date] = _prev_date), IF('Table'[Company 1] = CompanyOI, 'Table'[InfoCompany 1], 'Table'[InfoCompany 2]))