topic Re: Get particular column value if previous and current date data are different in DAX Commands and Tips

Get particular column value if previous and current date data are different

ghost10 — Fri, 14 Oct 2022 16:33:33 GMT

Hi Team,

I have columns called Snp rating , security id and holdings date.

Logic is get security id only if current date snp rating & previous date snp rating are different for same we should not get any security id.

Re: Get particular column value if previous and current date data are different

Stachu — Fri, 14 Oct 2022 16:49:22 GMT

Can you add sample tables (in format that can be copied to PowerBI) from your model with anonymised data? Like this (just copy and paste into the post window).

Column1	Column2
A	1
B	2.5

What do you consider a previous date in this scenario? Current date - 1 day, previous entry in the table, biggest date smaller than current, other? Also is there any additional key that's relevant (e.g. different companies/items that are rated on the same days? Can there be duplicate dates for single entity?

Also, are you looking for Dax or M solution?

Re: Get particular column value if previous and current date data are different

v-yinliw-msft — Mon, 17 Oct 2022 08:53:42 GMT

Hi ghost10 ,

You can try this method:

Here are my Sample data:

And then create a new table:

Result Table = SUMMARIZE ( 'Table', 'Table'[SecurityID], 'Table'[Snp rating], Table2[Current snp rating], "Select ID", IF ( 'Table'[Snp rating] = 'Table2'[Current snp rating], 'Table'[SecurityID], BLANK () ) )

Is this the result you expect?

Hope this helps you.

Best Regards,

Community Support Team _Yinliw

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