Forum Discussion
Compare data from two different table visuals that exist from different data sources
- Anonymous1 year ago
Please try this:
Here are 2 sample data:Table A:
Table B:
Click Transform data in the Home pane to use power query.
Click Custom Column in the Add Column pane:
You can use this m-code to get numbers from columns:
Text.Select([Value],{"0".."9","."})Add for both 2 tables:
Close&Apply.
Finally, add a measure:
MEASURE = COUNTROWS ( FILTER ( CROSSJOIN ( 'Table A', 'Table B' ), 'Table A'[Custom] = 'Table B'[Custom] ) )The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please try this:
Here are 2 sample data:
Table A:
Table B:
Click Transform data in the Home pane to use power query.
Click Custom Column in the Add Column pane:
You can use this m-code to get numbers from columns:
Text.Select([Value],{"0".."9","."})
Add for both 2 tables:
Close&Apply.
Finally, add a measure:
MEASURE =
COUNTROWS (
FILTER (
CROSSJOIN ( 'Table A', 'Table B' ),
'Table A'[Custom] = 'Table B'[Custom]
)
)
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.