Forum Discussion

Stones's avatar
Stones
Frequent Visitor
4 years ago
Solved

Find Sales from Calculated Column

Hi We have two sets of data, with very few relationships; product and date   One set of contains TV Advertising data; this data contains the Advert airtime along with the channel, programme, creat...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Stones , You can have new column in sales too

     


    new column in sales =
    var_1 = Countx(filter(Advertising Data, Advertising Data[Date] = Leads & Sales Data[Lead Date]
    && Leads & Sales Data[Lead Time In] >= Advertising Data[Date Time Aired]
    && Leads & Sales Data[Lead Time In] <= Advertising Data[Date Time Aired + 15-Min]), Advertising Data[Date])

    return
    if(isblank(_1),0,1)

     

    or you can populate lead id using maxx/minx

amitchandak's avatar
amitchandak
Super User
4 years ago

Stones , You can have new column in sales too

 


new column in sales =
var_1 = Countx(filter(Advertising Data, Advertising Data[Date] = Leads & Sales Data[Lead Date]
&& Leads & Sales Data[Lead Time In] >= Advertising Data[Date Time Aired]
&& Leads & Sales Data[Lead Time In] <= Advertising Data[Date Time Aired + 15-Min]), Advertising Data[Date])

return
if(isblank(_1),0,1)

 

or you can populate lead id using maxx/minx