Dear All Find the below Power BI table & visual page Tables: 1. Date = CALENDAR("1/1/2018", TODAY()) 2. Table 1 S.No BKG_ID FROM TO STATUS 1 IN19010001 CHENNAI BANGALORE CONFRIM 2 IN19010002 CHENNAI BANGALORE CANCEL 3 IN19010003 BANGALORE CHENNAI CONFRIM 4 IN19010004 BANGALORE CHENNAI CONFRIM 5 IN19010005 MUMBAI CHENNAI CONFRIM 6 IN19010006 MUMBAI AHMEDABAD CONFRIM 7 IN19010007 MUMBAI CHENNAI CONFRIM 8 IN19010008 CHENNAI MUMBAI CONFRIM 9 IN19010009 CHENNAI HYDERABAD CONFRIM 10 IN19010010 CHENNAI MADURAI CONFRIM 11 IN19010011 MADURAI CHENNAI CONFRIM 12 IN19010012 MADURAI BANGALORE CONFRIM 13 IN19010013 MADURAI MUMBAI CONFRIM 3. Table 2: DATE BKG_ID VIC_NUM CHR_CODE AMOUNT INV_NUM CHR_TYPE 17-Sep-18 IN19010001 TN05 M 3900 DISE -5000 E1900501 C 17-Sep-18 IN19010001 TN05 M 3900 RTO -350 E1900501 C 17-Sep-18 IN19010001 TN05 M 3900 TOL -730 E1900501 C 17-Sep-18 IN19010001 TN05 M 3900 FRT 7500 I19000503 R 10-Oct-18 IN19010003 TN05 M 3900 DISE -3000 E1900504 C 10-Oct-18 IN19010003 TN05 M 3900 RTO -350 E1900504 C 10-Oct-18 IN19010003 TN05 M 3900 TOL -730 E1900504 C 10-Oct-18 IN19010003 TN05 M 3900 FRT 5500 I19000506 R 25-Oct-18 TN05 M 3900 FC -8000 E1900509 C 15-Oct-18 IN19010004 TN05 G 5826 DISE -8000 E1900515 C 15-Oct-18 IN19010004 TN05 G 5826 RTO -550 E1900515 C 15-Oct-18 IN19010004 TN05 G 5826 TOL -1030 E1900515 C 15-Oct-18 IN19010004 TN05 G 5826 FRT 10500 I19000517 R 17-Oct-18 IN19010011 TN05 G 5826 DISE -3000 E1900534 C 17-Oct-18 IN19010011 TN05 G 5826 RTO -350 E1900534 C 17-Oct-18 IN19010011 TN05 G 5826 TOL -400 E1900534 C 17-Oct-18 IN19010011 TN05 G 5826 FRT 4500 I19000516 R 25-Oct-18 TN05 G 5826 TRE -2000 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 DISE -8000 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 RTO -550 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 TOL -1030 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 FRT 10500 I19000530 R 10-Nov-18 IN19010006 TN05 G 5826 DISE -3000 E1900540 C 10-Nov-18 IN19010006 TN05 G 5826 RTO -350 E1900540 C 10-Nov-18 IN19010006 TN05 G 5826 TOL -400 E1900540 C 10-Nov-18 IN19010006 TN05 G 5826 FRT 4500 I19000546 R 21-Nov-18 TN05 G 5826 TRE -2000 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 DISE -5000 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 RTO -350 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 TOL -730 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 FRT 7500 I19000602 R 17-Nov-18 IN19010008 TN05 M 3900 DISE -3000 E1900610 C 17-Nov-18 IN19010008 TN05 M 3900 RTO -350 E1900610 C 17-Nov-18 IN19010008 TN05 M 3900 TOL -730 E1900610 C 17-Nov-18 IN19010008 TN05 M 3900 FRT 5500 I19000606 R 20-Nov-18 TN05 M 3900 SER -3000 E1900609 C 21-Nov-18 IN19010009 TN05 G 5826 DISE -9000 E1900700 C 21-Nov-18 IN19010009 TN05 G 5826 RTO -750 E1900700 C 21-Nov-18 IN19010009 TN05 G 5826 TOL -1030 E1900700 C 21-Nov-18 IN19010009 TN05 G 5826 FRT 11500 I19000710 R 10-Dec-18 IN19010010 TN05 G 5826 DISE -2500 E1900708 C 10-Dec-18 IN19010010 TN05 G 5826 RTO -350 E1900708 C 10-Dec-18 IN19010010 TN05 G 5826 TOL -400 E1900708 C 10-Dec-18 IN19010010 TN05 G 5826 FRT 4500 I19000506 R 20-Dec-18 TN05 G 5826 MAIN -2000 E1900401 C 15-Dec-18 IN19010011 TN05 M 3900 DISE -3000 E1900415 C 15-Dec-18 IN19010011 TN05 M 3900 RTO -350 E1900415 C 15-Dec-18 IN19010011 TN05 M 3900 TOL -430 E1900415 C 15-Dec-18 IN19010011 TN05 M 3900 FRT 5500 I19000425 R 17-Dec-18 IN19010012 TN05 M 3900 DISE -8000 E1900435 C 17-Dec-18 IN19010012 TN05 M 3900 RTO -750 E1900435 C 17-Dec-18 IN19010012 TN05 M 3900 TOL -1250 E1900435 C 17-Dec-18 IN19010012 TN05 M 3900 FRT 12500 I19000455 R 20-Dec-18 TN05 M 3900 SER -3000 E1900552 C 21-Dec-18 IN19010013 TN05 M 3900 DISE -11000 E1900435 C 21-Dec-18 IN19010013 TN05 M 3900 RTO -750 E1900435 C 21-Dec-18 IN19010013 TN05 M 3900 TOL -1250 E1900435 C 21-Dec-18 IN19010013 TN05 M 3900 FRT 20500 I19000455 R 25-Dec-18 TN05 M 3900 SER -3000 E1900552 C 4. TABLE 3: Table3 = SUMMARIZE(Table2, Table2[Date1], Table2[BKG_ID],Table2[VIC_NUM],"AMOUNT", SUM(Table2[AMOUNT])) AM GET CORRECT OUTPUT FROM ABOVE TABLE; NEED REVERSE DATE AGAIN SAME FILTER example : From: Bangalore To: Chennai - am get Average Profit - Need reverse like From: Chennai & To is Blank when am select Filter From is Bangalore & To is Chennai
