Forum Discussion

gathenjic's avatar
gathenjic
Frequent Visitor
6 years ago

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_...
Data Protection
v-gizhi-msft's avatar
v-gizhi-msft
Community Support
6 years ago

Hi,

 

Please create a table like this by Enter Data:

Then create a check measure:

 

check = IF([TYpe of Monitoring]=SELECTEDVALUE(TypeSlicer[Type]),1,0)

 

Apply this measure to the original visual by setting check=1.

Choose the above [Type] as a slicer, when select one value, the result shows:

 

Best Regards,

Giotto Zhi

gathenjic's avatar
gathenjic
Frequent Visitor
6 years ago

v-gizhi-msft MFelix 

 

Amazing both dax worked. Great!!!!

 

Am discovering new things as i go.  Here is where I am stuck at, The activity can be repeated in the same district at different dates. How do i make the formular to look into specific dates for that specfiic round