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 ,
Measure are calculated based on context so the more values you add to your filters, slicers, visuals an so on the more the result of the measure changes so in this cases if you have the district and province the result will be done with the lowest level of granularity.