Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
AHoang
New Member

Get Value on Latest date only in date range selected via slicer

I am trying to use a slicer to return the start and end value of a portfolio. I have created measures to pick up the start date and end date selected.

AHoang_0-1625530176662.png

However, I can't pick up only the portfolio value at the end date only.

My first try was 

ENDPV = CALCULATE(SUM(Table1[PV]),FILTER(Table1,Table1[Date] == [EndDate]))
 
However, this didn't seem to work. EndDate gave me the right date when i displayed it on the page, but when I used it in a formula, it's just taken both dates selected (StartDate and EndDate) and added them together. 
 
Do you know how to fix this so that I can isolate the Starting Value and Ending Value? I need to report each separately so I can show how the portfolio value has changed over the selected time period

 

 

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@AHoang , if this coming from a date calendar then you can these two var to get first and last date

 

measure 2 =
VAR _min = MINX( allselected('Calendar') , 'Calendar'[Date] )
VAR _max = MAXX(allselected('Calendar') , 'Calendar'[Date] )
RETURN

<use in calculation >

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@AHoang , if this coming from a date calendar then you can these two var to get first and last date

 

measure 2 =
VAR _min = MINX( allselected('Calendar') , 'Calendar'[Date] )
VAR _max = MAXX(allselected('Calendar') , 'Calendar'[Date] )
RETURN

<use in calculation >

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors