undefined

[Leticia28]

I have a report I am trying to recreate in power bi. I have four columns modified on, modified by, created on, created by. I need counts for modified on is october and modified by is agent OR created on is october and created by is agent. I have tried and all I get is counts for modified on is october and modified by is agent AND created on is october and created by is agent. Theses are different numbers. I just need to know if it's possible and be pointed in the right direction. Thank you for any help you can give. Sorry if I posted twice.

[amitchandak · Accepted solution]

Assuming oct is selected in the slicer . Try

output 	=
Var _max_date= (max('Date'[Date Filer]))
Var   _min_date=(min('Date'[Date Filer]))

return
calculate(countrows(table),all(table[create_at]),all(table[modified_at])filter(table,( create_at >= _min_date && create_at <=_max_date && create_by = 'A')
|| ( create_at >=_min_date && create_at <=_max_date && create_by = 'A') ))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.

My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601