Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have 2 dates in my data model. One is customer start date and another is transaction date. There are 2 KPIs where I need these dates for calculation. New customers - Based on Customer Start Date and No of Policies - Based on transaction date.
Now the problem is the top filter section of Year, Month and Quarter. If i will derive the filters from customer date it will give wrong result for No of Policies. How do I join these two dates and create calendar that I can use in filter section.
let me know if you need more info.
Any suggestions would be appreciated.
Best Regards,
Neha
This may help you.Master Calender with 4 date fields
You may create a link table.