79141147

Date: 2024-10-30 12:43:56
Score: 1.5
Natty:
Report link

Something like that? enter image description here

Number of times appears Account = 

COUNTROWS(Tabla)

With this you've the number of times Account appears.

Now the MIN SORT

MIN SORT = 

var _MIN = CALCULATE(MIN(Tabla[Sort]))

RETURN

SUMX(VALUES(Tabla[Quarter Year]), CALCULATE(MIN(Tabla[Sort])))

With this you are obtaining the MIN SORT Value.

So you have a table where you can see MIN SORT and the number of times that an Account appears at the time period.

To check how appears in the case that you've more than one customer I've add customer 2.

Reasons:
  • Blacklisted phrase (1): enter image description here
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • Low reputation (1):
Posted by: Luis Miguel