Hello friends, I am dealing with an issue, and I request help,
I built a measure to show a count distinct of users filtered by some columns, but I need to use a conditional for Dates, I have already the conditional for the dates working fine in a fact table, but I need to introduce it on the formula measure, I just can't see how,
Initially I have added a similar condition (I thought it worked) but is not working:
I have tried this in order to match the two formulas, due to I thought that the condition CRM.contact_date ={"<=$(Date(Max(CRM.termstartdate)))"} from the 1. formula can potencially make what the 2. is doing, knowing that is not, I need to introduce #2. on#1.