Forum Discussion
Solved
Formula
Hi, I am trying to pull back the count of the account in another table, but also include a filter to select the date. Currently for the count, it is just bringing back a total instead of it...
You could use
Jan'25 = CALCULATE ( COUNTROWS ( Event ), FILTER ( Event, Event[Account Name] = Test[Name] && Event[Activity Date (Month Year)] = "Jan 2025" ) )
Perfect, that has worked!
How do I add another filter into the same query to only return anything with a January date? I have a column in the event table called Month Year so I can reference that.
Using the below but it won't work with the second part of the filter.
Jan'25 = CALCULATE(
COUNTROWS(Event),
FILTER(Event,Event[Account Name]
=(Test[Name],
Event,Event[Activity Date (Month Year)]
="Jan 2025")))
Thanks!
You could use
Jan'25 =
CALCULATE (
COUNTROWS ( Event ),
FILTER (
Event,
Event[Account Name] = Test[Name]
&& Event[Activity Date (Month Year)] = "Jan 2025"
)
)