Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Measure filtered by dates

Hello - My measure below returns results as expected until the underlined part. I need to add more filtering with dates that I can't seem to do. I want to be able to say X date (related table) is les...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

Hi Anonymous ,

 

Please try this one.

Measure 2 =
VAR d =
    MAX ( Opportunity[CreatedOn] )
RETURN
    CALCULATE (
        COUNT ( Opportunity[OpportunityId] ),
        FILTER (
            altus_leadstage,
            altus_leadstage[altus_name] = "MQL"
                && altus_leadstage[altus_Date] < d
        ),
        USERELATIONSHIP ( Opportunity[ParentContactId], altus_leadstage[altus_Contact] )
    )