Forum Discussion
Helper IIIFinding MAX in each category
- You could try this as a calc column:
IsMax - IF( 'Table1'[Transaction] a MAXX(FILTER(ALL('Table1'), 'Table1'[Name] ? EARLIER('Table1'[Name])), 'Table1'[Transaction]), "Yes", "No")
Helper IIIAll the solutions provided by AllisonKennedy mahoneypat Anonymous have actually worked.
Can I add one more similar question to it? This will remove the unnecessary tables and improve the data model.
Lets say I have just 1 field:
Field:
A01/01/2020
A01/01/2020
A01/01/2020
A03/12/2020
B02/11/2020
B03/29/2020
Is it possible to add a new calculated column which give the counts:
Example: records 1,2 and 3 will give 3 each because they belong to the same category (A01/01/2020) and then 4,5,6 gives 1 each.
Helper IIIThank you Anonymous. This is really amazing!
Sorry too many questions but this is my last one (which is basically a combination of my first and previous question) - In the below example A01/01/2020 has the highest count (appearing thrice) so I need a "Yes" in front of them. Simlarly B has the highest on 24/02/2020 (appearing twice). If you can help me here as well that would be really helpful so that I can close my series of questions.
Name: Column (needed)
A01/01/2020 Yes
A01/01/2020 Yes
A01/01/2020 Yes
A15/03/2020 No
A20/04/2020 No
B12/01/2020 No
B24/02/2020 Yes
B24/02/2020 Yes