I am problem changing from "42005" date format to "201501" . although both table's KPI_DATE have been linked together. How can i make it to same? below is the format i have applied, resulted "42005" after the changes.
Date(Date#(KPI_DATE, 'YYYYMM'), 'YYYYMM') as KPI_DATE,