Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filtering one visual using a date from another visual

I'm doing reporting from Salesforce.   In my model I have Campaign and Opportunity.   Campaign has a start date and represents a marketing campaign.   Opportunity has a start date.   When I s...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi Anonymous,

    Please create a measure using the formula below and check if it works fine.

    Measure =
IF (
    FIRSTNONBLANK ( opportunit[startdate], opportunit[startdate] )
        > SELECTEDVALUE ( Campaign[start date] ),
    "True",
    "Flase"
)


    Please feel free to ask if you have any other issue.

    Best Regards,
    Angelia


parry2k's avatar
parry2k
Super User
8 years ago

Does these tables have relations? Can you share sample data in excel?