Forum Discussion

Anonymous

Not applicable

6 years ago

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...

Icon for Super User rank

Super User

6 years ago

Anonymous , 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

parry2k
Super User
6 years ago
Anonymous not sure how tables are connected like slicers are from disconnected tables, you have to add your calculation as measures, not columns

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
- Anonymous
  Not applicable
  6 years ago
  These are the tables from where slicer data is coming.
  I have added the calculation measure and i cannot summarize the data. I can only summarize the data with a column.
  My goal here is to create a summarized table as shown in my post.
  - richbenmintz
    Resident Rockstar
    6 years ago
    Hi Anonymous,
    
    If you can provide the .pbix file I am pretty sure that parry2k , amitchandak or myself can help you with the measure you are looking for.
    
    Thanks,
    
    Richard
Anonymous
Not applicable
6 years ago

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.

Related content