Forum Discussion
CLQ
Helper I
3 years agoGet the repeated values in a table, using, if possible, calculatedtable
Hello everyone. I have the following table (Table1): Name Order Date Day Month Store Jhon 2022/06/01 1 6 TV Jhon 2022/06/01 1 6 TV Jhon 2022/07/01 1 7 TV Kelly...
- 3 years ago
Hi CLQ ,
You can try this method:
Result = VAR _table = FILTER ( 'Table', AND ( 'Table'[Month] = 6, 'Table'[Store] = "TV" || 'Table'[Store] = "Xbox" ) ) VAR _table1 = GROUPBY ( _table, [Name], "num", COUNTX ( CURRENTGROUP (), [Name] ) ) RETURN SUMMARIZE ( FILTER ( _table1, [num] > 1 ), [Name] )The result is:
Hope this helps you.
Here is my PBIX file.
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
Community Support
3 years agoHi CLQ ,
You can try this method:
Result =
VAR _table =
FILTER (
'Table',
AND ( 'Table'[Month] = 6, 'Table'[Store] = "TV" || 'Table'[Store] = "Xbox" )
)
VAR _table1 =
GROUPBY ( _table, [Name], "num", COUNTX ( CURRENTGROUP (), [Name] ) )
RETURN
SUMMARIZE ( FILTER ( _table1, [num] > 1 ), [Name] )
The result is:
Hope this helps you.
Here is my PBIX file.
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.