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

[ghost10]

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.

[v-yinliw-msft · Accepted solution]

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.

[Stachu]

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?