Forum Discussion

GuidoPinares's avatar
GuidoPinares
Helper I
3 years ago
Solved

Track time activity

Hello Community,   Thanks so much for taking the time to review this, I have 3 tables as follows:   Sales (SaleID, DateOfSale, Customer, Quantity) Activity (SaleID, DateOfActivity, Customer) Cu...
Need Help
amitchandak's avatar
amitchandak
Super User
3 years ago

GuidoPinares , You can have new column like

 

New column =

var _cnt = countx(filter(Activity, Activity[Customer] = sales[customer] && Activity[Date] < sales[Date]) , Activity [Customer])

var _cntSalesbefore = countx(filter(sales, sales[Customer] = earlier(sales[customer]) && sales[Date] < earlier(sales[Date]))  , sales[Customer])

return

if(isblank(_cntSalesbefore ), _cnt, blank())

 

Returning count only when there are no sales before

 

refer if needed

refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8

 

Power BI DAX- Earlier, I should have known Earlier: https://youtu.be/CVW6YwvHHi8
https://www.youtube.com/watch?v=cN8AO3_vmlY&t=17820s