Forum Discussion
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...
Hi, this is stil an issue.
It works fine for the current fiscal years 19/20, however if I go back to the fiscal year 18/19 that's when I get the discrepancies in the data.
The left visual is when I tried using the filter that was suggested above
RHB Leads =
CALCULATE(
[RHB Leads - Count],FILTER(Opportunity,FORMAT(Opportunity[RHB Created On],"MMDD")>="0401"),
USERELATIONSHIP('Opportunity'[RHB Date of Enquiry], 'Full Date'[Full Date]))The right visual is when I put in a filter on in the filter plain, like so
Thanks,
Mike
Hi,
Still struggling on this issue
Can anyone help?
Thanks,
Mike
Bump