undefined

[MAP]

How to get only last Friday closing rate of a stock dynamically in power bi dax 

[MAP]

Thanx for your solution , It works fine, but I have a date slicer in my report page which  do not effect my last friday closing rate, In other words I always get last friday closing rate irrespective of date selection

[Fowmy]

@MAP 

Explain your requirements a bit more clarly and provide mode details on how your data model is organized.
Better, you could attach a sample PBIX file using a OneDrive or GoogleDrive.

[Fowmy]

@MAP 

Try:

Last Friday Rate = 
VAR __LastFriday = MAXX( FILTER( VALUES( Stocks[Date] ) , WEEKDAY( Stocks[Date]  ,1 ) = 6 ) , Stocks[Date] )
VAR __Result = CALCULATE( MAX(Stocks[Closing Rate]) , Stocks[Date] = __LastFriday )
RETURN
   __Result

[MAP]

Thanx for your solution. It works fine but I have a date slicer on my report page ,whatever date I will select from the date slicer your solution won't take changes according to selected date ,in other words slicer don't effect this measure and give me last friday closing rate dynamically. You got it my point.....! 

[rohit1991]

1.  Add DayOfWeek Column: DayOfWeek = WEEKDAY(Date[Date], 2) // 5 = Friday
2. Find Last Friday: LastFriday =
   CALCULATE(
   MAX('Date'[Date]),
   FILTER('Date', 'Date'[DayOfWeek] = 5 && 'Date'[Date] <= MAX('Date'[Date]))
   )
   
   
3. Get Closing Rate: LastFridayClosingRate =
   CALCULATE(
   SUM(StockData[ClosingRate]),
   StockData[Date] = [LastFriday]
   )
   This will dynamically return the last Friday's closing rate.