topic undefined in DAX Commands and Tips

undefined

MAP — Sat, 25 Jan 2025 05:07:56 GMT

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

Re: undefined

rohit1991 — Sun, 27 Jul 2025 09:05:44 GMT

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.

Re: undefined

Fowmy — Sat, 25 Jan 2025 13:48:46 GMT

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

Re: undefined

MAP — Sun, 26 Jan 2025 17:59:38 GMT

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.....!

Re: undefined

MAP — Sun, 26 Jan 2025 18:09:21 GMT

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

Re: undefined

Fowmy — Mon, 27 Jan 2025 07:09:17 GMT

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.