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]

Hi @MAP ,

You can do this with a measure that always gets the last available Friday’s closing rate, no matter what’s selected in your slicer. Try this: 

Last Friday Closing Rate =
VAR LastFriday =
    CALCULATE(
        MAX(Stocks[Date]),
        FILTER(
            ALL(Stocks),
            WEEKDAY(Stocks[Date], 2) = 5
        )
    )
RETURN
    CALCULATE(
        MAX(Stocks[Closing Rate]),
        FILTER(
            ALL(Stocks),
            Stocks[Date] = LastFriday
        )
    )

This measure ignores any date filter or slicer and always finds the most recent Friday in your dataset, then pulls the closing rate for that date. If there’s a missing Friday (holiday, etc), it’ll just grab the latest one that exists. If you have multiple stocks and want the last Friday closing for each one, you can wrap the logic in an additional filter by ticker.