Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
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.
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?
User | Count |
---|---|
53 | |
28 | |
19 | |
18 | |
14 |
User | Count |
---|---|
92 | |
86 | |
39 | |
23 | |
22 |