topic Re: Shares price match with previous price in DAX Commands and Tips

Shares price match with previous price

MAP — Sat, 10 Aug 2024 10:16:55 GMT

I am currently working on stock market data in Power BI and need to create a DAX measure that identifies when a stock’s price approximately matches a given value on previous days. For example, if the price of XYZ shares is 120, I want to find out when the price of XYZ shares was approximately 120 on previous days.

Re: Shares price match with previous price

SachinNandanwar — Sat, 10 Aug 2024 13:55:57 GMT

Hi MAP

Are there any business rules that defines how close the approximate value should be ? For example if price was 80 so would that be considered close to 120 ?

Re: Shares price match with previous price

Anonymous — Sat, 10 Aug 2024 16:48:08 GMT

Since I dont have your sample data and your idea of approximate price, I have implemented my idea here.
I have taken all the historical data of tata motors from Yahoo finance.

Source Data

First the closing price is rounded off

Now latest price is found

Starting digit of latest price is found

Number of digits in the latest price is found

Nearest Lowest round figure is found

Nearest highest round figure is found

Required date indicators is found

Filtered the "Price Indicator" text in the final column

I hope you have your answer. If my answer is satisfying with your criteria then please accept the same as your solution.

Re: Shares price match with previous price

MAP — Sun, 11 Aug 2024 06:03:08 GMT

If price is 120 then 120.01 to 120.99 will be consider close

Re: Shares price match with previous price

MAP — Sun, 11 Aug 2024 06:11:05 GMT

Thank you for replying. I'll see if your answer fulfills what I want.

Re: Shares price match with previous price

Anonymous — Mon, 12 Aug 2024 07:53:46 GMT

Thanks for the reply from Rakesh1705 and SachinNandanwar , please allow me to provide another insight:

Hi, MAP

Can you tell me if your problem is solved? If yes, please accept their as solution.

Regarding the issue you raised, my solution is as follows:

1.First I have created the following table and the column names and data are the data you have given:

2.First, you can try using the following calculation table, using its id column as a slicer:

Table 2 = SELECTCOLUMNS('Table','Table'[ID],'Table'[date])

3.Second, use the following measures and modify the filters:

MEASURE = VAR nday = MAX ( 'Table 2'[Table_date] ) VAR nprice = MAXX ( FILTER ( ALLSELECTED ( 'Table' ), 'Table'[date] = nday ), 'Table'[price] ) VAR selce11 = MAX ( 'Table 2'[Table_ID] ) RETURN IF ( ISFILTERED ( 'Table 2'[Table_ID] ), IF ( ABS ( MAX ( 'Table'[price] ) - nprice ) < 1 && MAX ( 'Table'[ID] ) = selce11, 1, 0 ), 1 )

4.Here's my final result, which I hope meets your requirements.

Please find the attached pbix relevant to the case.

Of course, if you have any new ideas, you are welcome to contact us.

Best Regards,

Leroy Lu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.