Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

DAX SQL window function equivalent

Hello,   I would like to create a calculated column that returns a total row count per customer, as below.   http://imgur.com/WJ2MzJS   To do this with SQL, one approach would be to use a windo...
Need Help
  • Eric_Zhang's avatar
    Eric_Zhang
    9 years ago

    Anonymous

    Check

     

    Column =
COUNTAX (
    FILTER ( 'Table', EARLIER ( 'Table'[Customer No.] ) = 'Table'[Customer No.] ),
    'Table'[Product Purchased]
)

     

     

    A good site for your reference.

Eric_Zhang's avatar
Eric_Zhang
Microsoft Employee
9 years ago

Anonymous

Check

 

Column =
COUNTAX (
    FILTER ( 'Table', EARLIER ( 'Table'[Customer No.] ) = 'Table'[Customer No.] ),
    'Table'[Product Purchased]
)

 

 

A good site for your reference.

  • Shmidtk's avatar
    Shmidtk
    New Member
    8 years ago

    What if we have unsorted list of Customer No.? They this formula shouldn't work, yes?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Lovely, thanks very much.