cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bkirshenbaum Frequent Visitor
Frequent Visitor

Display Last Value within Range Specified by Slicer

Hello!

 

I'm trying to build a report that shows values relative to the current date for a variety of properties in a table.

 

Property NamePre Lease %Occupied %Web Traffic
Site A55%25%37
Site B65%20%53
Site C75%15%48

 

Example: If I set the Date Slicer to 3 months ago, I want it to show me the data that was entered nearest to February 6th (3 months ago). However, it seems I only have the ability to pull the average, sum, etc of the values from that range. These values are entered in to our database weekly, so if I set it to "Do Not Summarize", I get a ton of Site A, Site B, and Site C lines, each with their own entry.

 

Thank you for your help and I'm happy to provide more context if necessary!

 

 

2 REPLIES 2
v-danhe-msft Super Contributor
Super Contributor

Re: Display Last Value within Range Specified by Slicer

Hi @bkirshenbaum ,

Could you please post some simple sample data and your desired result to have a test if possible? Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
bkirshenbaum Frequent Visitor
Frequent Visitor

Re: Display Last Value within Range Specified by Slicer

Sorry about that!

 

Below is the sample data, and I am trying to filter based upon the Modified Date. There are several entries for each property throughout time, and when we filter via the slicer, we want to be able to capture a single piece of data that is closest to the relative date selected and display it in a table or matrix.

 

Thank you!

Property ID:Property NameOccupiedcalcOccupiedcalcPreleasedPre LeasedWeekly TrafficCompetition RankModified
identity000000Monday, January 22, 2018
tower10010.181801Monday, January 22, 2018
4th street000002Monday, January 22, 2018
advenir900.90003Monday, January 22, 2018
advenir900.90043Monday, January 22, 2018
4th street980.980002Monday, January 22, 2018
tower10010.181801Monday, January 22, 2018
tower99.630.99630.223222.3241Monday, February 12, 2018
4th street980.980.33002Monday, February 12, 2018
advenir900.90043Monday, February 12, 2018
advenir900.90043Monday, February 12, 2018
advenir000003Monday, February 12, 2018
tower10010.33071Thursday, March 1, 2018
4th street970.970.353542Thursday, March 1, 2018
advenir000003Thursday, March 1, 2018
4th street980.980.33002Thursday, March 8, 2018
advenir000003Thursday, March 8, 2018
advenir000003Thursday, March 8, 2018
tower10010.33071Thursday, March 8, 2018
4th street 00   Friday, March 16, 2018
4th street980.980.323252Friday, March 16, 2018
4th street980.980.514251.42122Friday, March 23, 2018
4th street970.970.551655.16212Friday, March 30, 2018
4th street970.970.5757212Friday, April 6, 2018
tower10010.660251Friday, June 22, 2018
advenir810.810.878703Friday, June 22, 2018
4th street950.950.990432Tuesday, June 26, 2018
4th street950.950.990432Tuesday, July 10, 2018
4th street950.950.990432Tuesday, July 10, 2018
tower10010.660251Tuesday, July 10, 2018
tower10010.660251Tuesday, July 10, 2018
tower10010.7575121Thursday, July 19, 2018
4th street950.950.9494282Thursday, July 19, 2018
advenir860.860.888803Thursday, July 19, 2018
tower10010.770121Thursday, July 19, 2018
fountain000000Monday, July 23, 2018
tower10010.990201Friday, July 27, 2018
advenir890.890.919193Friday, July 27, 2018
fountain000000Friday, July 27, 2018
identity000000Thursday, September 13, 2018
tower10010.990201Thursday, September 13, 2018
4th street950.950.9898282Thursday, September 13, 2018
4th street980.9800282Thursday, September 13, 2018
advenir890.890.919193Thursday, September 13, 2018
advenir890.890.919193Thursday, September 13, 2018
fountain000000Thursday, September 13, 2018
fountain960.9600153Thursday, September 13, 2018
fountain960.9600153Thursday, September 13, 2018
tower100100101Thursday, September 13, 2018
identity000000Thursday, September 20, 2018
tower100100101Thursday, September 20, 2018
tower10010001Thursday, September 20, 2018
4th street970.970.03382Thursday, September 20, 2018
advenir850.850093Thursday, September 20, 2018
fountain960.9600153Thursday, September 20, 2018
fountain960.960093Thursday, September 20, 2018
identity000000Thursday, September 27, 2018
tower100100122Thursday, September 27, 2018
4th street970.970.03381Thursday, September 27, 2018
advenir850.850083Thursday, September 27, 2018
fountain960.960093Thursday, September 27, 2018
fountain960.960093Thursday, September 27, 2018
fountain960.9600114Thursday, September 27, 2018
4th street980.980.05581Thursday, September 27, 2018
identity000000Thursday, October 4, 2018
tower100100122Thursday, October 4, 2018
4th street970.970.01171Thursday, October 4, 2018
fountain 00   Thursday, October 4, 2018
fountain95.610.956100114Thursday, October 4, 2018
advenir850.850063Thursday, October 4, 2018
tower10010052Thursday, October 4, 2018
identity000.0000160.001600Thursday, October 11, 2018
tower10010002Thursday, October 11, 2018
4th street980.980.01161Thursday, October 11, 2018
advenir850.850063Thursday, October 11, 2018
advenir850.850033Thursday, October 11, 2018
fountain95.610.956100114Thursday, October 11, 2018
fountain95.610.95610064Thursday, October 11, 2018
advenir850.850053Thursday, October 18, 2018
fountain95.610.95610054Thursday, October 18, 2018
identity000.0000160.001600Thursday, October 18, 2018
4th street980.980.01131Thursday, October 18, 2018
tower10010002Thursday, October 18, 2018
tower10010002Thursday, October 18, 2018
tower990.990.02212.2152Thursday, October 18, 2018
identity000.0000160.001600Thursday, October 25, 2018
advenir 00   Thursday, October 25, 2018
advenir83.440.83440083Thursday, October 25, 2018
fountain95.610.95610054Thursday, October 25, 2018
fountain95.610.95610054Thursday, October 25, 2018
tower990.990.03352Thursday, October 25, 2018
4th street990.990.04094.0941Thursday, October 25, 2018
advenir83.440.83440083Thursday, October 25, 2018
fountain970.970034Thursday, October 25, 2018
identity000.00320.3200Thursday, November 1, 2018
4th street990.990.0747.441Thursday, November 1, 2018
advenir82.70.8270053Thursday, November 1, 2018
fountain970.970034Thursday, November 1, 2018
fountain970.970034Thursday, November 1, 2018
fountain970.970024Thursday, November 1, 2018
tower990.990.03362Thursday, November 1, 2018
tower990.990.0353.562Thursday, November 1, 2018
identity000.00640.6400Thursday, November 8, 2018
advenir82.70.8270023Thursday, November 8, 2018
fountain950.950074Thursday, November 8, 2018
4th street990.990.11081Thursday, November 8, 2018
tower98.90.9890.07757.7552Thursday, November 8, 2018
identity000.00970.9700Thursday, November 15, 2018
advenir82.780.82780043Thursday, November 15, 2018
tower990.990.11052Thursday, November 15, 2018
advenir82.780.82780043Thursday, November 15, 2018
4th street990.990.11081Thursday, November 15, 2018
fountain950.950074Thursday, November 15, 2018
4th street990.990.11081Wednesday, November 21, 2018
tower990.990.11052Wednesday, November 21, 2018
tower990.990.11052Wednesday, November 21, 2018
identity000.00970.9700Wednesday, November 21, 2018
identity000.00970.9700Wednesday, November 21, 2018

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 144 members 1,604 guests
Please welcome our newest community members: