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,

 

Could you please tell me that why the column in your formula such as [SIAs Start Date] or [SIAs End Date]does not exist in your sample table?

Please share the expected result as a screenshot for me to help you further.

You can share your pbix file by OneDrive for Business if convenient.

And remember to remove any sensitive data.

Thanks.

 

Best Regards,

Giotto Zhi