Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |