Forum Discussion

ghost10's avatar
ghost10
Frequent Visitor
4 years ago
Solved

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

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 ...
  • v-yinliw-msft's avatar
    v-yinliw-msft
    4 years ago

    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.

v-yinliw-msft's avatar
v-yinliw-msft
Icon for Community Support rankCommunity Support
4 years ago

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.