Forum Discussion
Summarizing columns from three different date ranges(Please let me know if this the correct approah)
I have created a report that would filter based on three date ranges as below DateFilterRange = IF(MAX(vw_patientListNew[StatusDate]) in UNION(VALUES(DateRange1[Date]),VALUES(DateRange2[Da...
amitchandak
Super User
Super UserAnonymous , three slicers should be coming from three date tables or three-column. You might have ignore the other when one is working.
refer to this example for two date ranges
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Spoiler
amitchandak Yes the slicers are coming from three different date tables, exactly as you mention in the article link.
As you can see above the slicer data is coming from three different tables.