Forum Discussion
Summarizing columns from three different date ranges(Please let me know if this the correct approah)
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
Super UserAnonymous 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.⚡
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.
richbenmintzResident Rockstar
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
The site doesn't let me upload file.
Data:
StatusDate InterventionType 7/21/1989 0:00 Interventional TX 1/8/1990 0:00 Interventional TX 4/30/1990 0:00 Interventional TX 11/3/2006 0:00 Interventional Non TX 11/6/2006 0:00 Interventional TX 11/8/2006 0:00 Interventional Non TX 11/9/2006 0:00 Interventional TX 11/13/2006 0:00 Interventional TX 11/14/2006 0:00 Interventional Non TX 11/14/2006 0:00 Interventional TX 11/15/2006 0:00 Interventional Non TX 11/16/2006 0:00 Interventional TX 11/17/2006 0:00 Interventional Non TX 11/20/2006 0:00 Interventional TX 11/22/2006 0:00 Interventional Non TX 11/22/2006 0:00 Interventional TX 11/27/2006 0:00 Interventional TX 11/28/2006 0:00 Interventional Non TX 11/28/2006 0:00 Interventional TX 11/30/2006 0:00 Interventional Non TX 11/30/2006 0:00 Interventional TX 12/1/2006 0:00 Interventional Non TX 12/1/2006 0:00 Interventional TX 12/4/2006 0:00 Interventional TX 12/5/2006 0:00 Interventional TX 12/6/2006 0:00 Interventional TX 12/7/2006 0:00 Interventional TX 12/11/2006 0:00 Interventional Non TX 12/11/2006 0:00 Interventional TX 12/12/2006 0:00 Interventional Non TX 12/12/2006 0:00 Interventional TX 12/13/2006 0:00 Interventional Non TX 12/14/2006 0:00 Interventional TX 12/15/2006 0:00 Interventional Non TX 12/18/2006 0:00 Interventional Non TX 12/19/2006 0:00 Interventional Non TX 12/19/2006 0:00 Interventional TX 12/20/2006 0:00 Interventional Non TX 12/20/2006 0:00 Interventional TX 12/21/2006 0:00 Interventional Non TX 12/21/2006 0:00 Interventional TX 12/22/2006 0:00 Interventional Non TX 12/27/2006 0:00 Interventional TX 12/28/2006 0:00 Interventional TX 1/2/2007 0:00 Interventional Non TX 1/4/2007 0:00 Interventional TX 1/5/2007 0:00 Interventional Non TX 2/24/2020 0:00 Interventional Non TX 2/24/2020 0:00 Interventional TX 2/25/2020 0:00 Interventional Non TX 2/25/2020 0:00 Interventional TX 2/26/2020 0:00 Interventional Non TX 2/26/2020 0:00 Interventional TX 2/27/2020 0:00 Interventional Non TX 2/27/2020 0:00 Interventional TX 2/28/2020 0:00 Interventional Non TX 2/28/2020 0:00 Interventional TX 3/1/2020 0:00 Interventional Non TX Desired Results :
Slicer1(1/1/1989 - 7/26/1990) Slicer2(11/3/2006 - 1/5/2007) Slicer3(2/24/2020-3/1/2020) Interventional TX 3 24 5 Interventional Non TX 0 20 6 I have three slicers: