Forum Discussion
How to count duplicate values across multiple columns
- 2 years ago
Camstr Easiest thing you can do is go into Power Query Editor, select your Name column, right-click and choose "Unpivot other columns". Then you don't need DAX. If for some reason you want to leave your data as is, then you will need something like MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Fabric Community
Also, there are equivalents for COUNTIF in DAX: Excel to DAX Translation - Microsoft Fabric Community
Camstr Easiest thing you can do is go into Power Query Editor, select your Name column, right-click and choose "Unpivot other columns". Then you don't need DAX. If for some reason you want to leave your data as is, then you will need something like MC Aggregations: Multi-Column Aggregations (MC Aggregations) - Microsoft Fabric Community
Also, there are equivalents for COUNTIF in DAX: Excel to DAX Translation - Microsoft Fabric Community
Greg_Deckler awesome, exactly what I needed.
Thank you