Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
Having trouble understanding how to include/exclude total sales within a date filter (from same period last year and current year) if the store was either opened within the date filter dates or closed within the date filter dates both this year and same period last year.
For example, my date filter is set from 1/1/17..8/31/17. I want to exclude stores that were closed or opened on 6/1/2016 and stores that were opened on 5/1/17. Basically, only stores that were open throughout the entire date filter. I want this to be able to recalculate when the date filter is changed by the end user.
Any ideas would be appreciated.
Thanks!
This post seems to have a similar requirement and a solution.
https://community.powerbi.com/t5/Desktop/Filtering-within-a-date-range/td-p/227767
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
117 | |
101 | |
71 | |
61 |