Forum Discussion
Find data from one column to another
Hello, good morning.
I need to know if certain users meet the data in a column in the same table.
In my example it would be:
Column cta_numero should have from column ope_id_moneda (2, 80 and 98) if that condition is met would be a complete account, otherwise not.
How could I solve it?
Hi , Syndicate_Admin
According to your description, you want to get the certain [cta_numero] who have (2,80,98). Right?
Here are the steps you can refer to :
(1)This is my test data :
(2)We can click "New Table" to create a table:
Table 2 = FILTER( SUMMARIZE('Table','Table'[cta_numero] , 'Table'[open_id_moneda]) , [open_id_moneda] in {2,80,98})(3)Then we can put the table fileds on the visual , and then we can get waht we want :
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
2 Replies
New measure =
var _cnt = countx(allselected(Table), [cta_numero] = max(Table[cta_numero]) && [ope_id_moneda] in {2,80,98}))
return
calculate(count(Table[cta_numero]), filter(Table, not(isblank(_cnt )) ) )
Hi , Syndicate_Admin
According to your description, you want to get the certain [cta_numero] who have (2,80,98). Right?
Here are the steps you can refer to :
(1)This is my test data :
(2)We can click "New Table" to create a table:
Table 2 = FILTER( SUMMARIZE('Table','Table'[cta_numero] , 'Table'[open_id_moneda]) , [open_id_moneda] in {2,80,98})(3)Then we can put the table fileds on the visual , and then we can get waht we want :
If this method does not meet your needs, you can provide us with your special sample data and the desired output sample data in the form of tables, so that we can better help you solve the problem.
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
