Forum Discussion

michael_knight's avatar
michael_knight
Icon for Post Prodigy rankPost Prodigy
6 years ago

Work a Date Filter into a Measure

Hi,   I've got this filter on one of my visuals  This is the measure that I've used for the visual above  Leads (RHB) - Count = COUNTA(Opportunity[RHB Date of Enquiry]) I also have anot...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi @michaelknight94,

 

If I understand you correctly, you can modify your measure as below:

RHB Leads =

CALCULATE (

    [RHB Leads - Count],

    FILTER (

        Opportunity,

        FORMAT ( Opportunity[RHB Date of Enquiry], "YYYYMM" ) >= "201704"

            && FORMAT ( Opportunity[RHB Date of Enquiry], "YYYYMM" ) < "201804"

    ),

    USERELATIONSHIP ( 'Opportunity'[RHB Date of Enquiry], 'Full Date'[Full Date] )

)

Or create a slicer and result would be shown as below:

 

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.