Forum Discussion
Dax help : advanced date allocation between tables
Hi, I would like to generate "Fulfill date" in table 1. Table 1 is the sales order by its site, sales order, line and SKUs. It lists down the date that customers would like to deliver. So in tab...
table 1
add colnum
Batch = rankx(filter(table 1,Site=eariler(Site) && SKU = eariler(SKU), Date,Date,asc)
add colnum
index = Batch & SKU & Site
table 2
add colnum
index = Batch & SKU & Site
link 2 index colnum
