virtual table create with next contact columns
Hi, I'm already desperate. I need advice on the next task. I want to create a virtual table. In the table, create a new column named Next Contact. I want to know when the number in the CD_MSISDN column called the next one again if it called. I can't find the right results. I try more measures.. Fox example. DEFINE var curr_CD_MSISDN = max(Query1[CD_MSISDN]) var this_date = CALCULATE(min(Query1[TS_ENTERED_QUEUE]),filter(Query1,Query1[CD_MSISDN]=curr_CD_MSISDN)) VAR v1 = ADDCOLUMNS ( SUMMARIZE ( Query1, Query1[CD_MSISDN], Query1[TS_ENTERED_QUEUE] ), "NEXT Contact", CALCULATE ( CALCULATE(min(Query1[TS_ENTERED_QUEUE]),ALLEXCEPT(Query1,Query1[CD_MSISDN]) ,Query1[TS_ENTERED_QUEUE]>this_date) ) ) EVALUATE v1 This returns. Red is an example of the correct result. I think the problem is in setting the correct filter context for the variables "Curr_CD_MSISDN" and "this date". But I can't solve it. Can anyone please advise me?
