Forum Discussion
How to Assign text value based on dates while the date variable are in 2 different tables
I have 2 tables. Table1 for campaign monitoring which have date_monitored Table 2: is for campaign calendar - it has Campaign_start_date, Campaign_end_date, Monitoring_start_date and Monitoring_end_...
The measure takes in the start date and end date irresppective of the location (district)See the marked are the 2 dates that the measure is using to assign IN or END process. My extection is it will evaluate based on the district too
Hi gathenjic ,
You want the all the lines presented show the same value on the measure or for each one should be a diffenrent value?
MFelix , the Value should differ based on dates supplied on related row in both tables. I think its more about defining how the relationships are and at the same time there is no unique key in either but are related to a master district tabled
District Response_Type Activity_Start_Date Activity_End_Date Post_start_Date Post_End_Date District1 Round 1 07/02/2020 11/02/2020 12/02/2020 15/02/2020 District2 Round 1 07/02/2020 11/02/2020 12/02/2020 15/02/2020 District1 Round 2 14/03/2020 18/03/2020 20/03/2020 25/03/2020 District2 Round 2 14/03/2020 18/03/2020 20/03/2020 25/03/2020 Province district date_monitored Province1 District1 07/02/2020 Province1 District1 08/02/2020 Province1 District2 09/02/2020 Province1 District2 10/02/2020 Province1 District1 11/02/2020 Province1 District1 14/04/2020 Province1 District1 15/03/2020 Province1 District1 15/03/2020 Province1 District2 16/03/2020 Province1 District2 14/03/2020 Can you please add the result you want on the last table based on the date selection?
Thank you