Forum Discussion
Helper ICheck if a date is between two others from another table
Hello,
I have this model which concerns transactions and marketing campaigns.
I want to know how is it possible to check if transcation date from transcactions table is between start and end date from Campaigns Table. Related function is not working, therefore i cannot set up the if statements.
Thanks!
You can calculate a new column like
maxx(filter(Table2, Table[Date] >= Table2[Start date] && Table[Date] <= Table2[end date] ), Table[value])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
2 Replies
- amitchandak
Super User
You can calculate a new column like
maxx(filter(Table2, Table[Date] >= Table2[Start date] && Table[Date] <= Table2[end date] ), Table[value])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
IliasKatsisHello again.. There is another issue. Every coupon id from the transcations table is included to some campaigns. Each campaign has a specific number of coupon id. Campaign details is the table to take this information. How is it possible to combine the start and end date from my previous question with the constraint of that the coupon id must be included to a campaign id.
Thanks