cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

undefined

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.
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: undefined

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

1 REPLY 1
Highlighted
Super User IX
Super User IX

Re: undefined

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors