Forum Discussion
Solved
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.
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
1 Reply
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