TSQL GroupBy with Having

[Oded-Dror]

Hi there,

How do I convert TSQL to DAX
Select CustomerID
From Customer
Where CreatedDT >= 1/1/2022 And CreatedDT <= 1/31/2022
Group by CustomerID
Having Max(NewCustomerID) = 1  ---------- This is another column

In DAX I did
Filter(
    GroupBY(
            Customer,
            CreateDT
            NewCustomerID
       )
, Customer[CreatedDT] >= 20220101 && Customer[CreatedDT] <= 20220131 &&
Customer(NewCustomerID) = 1 ------ DAX not allowed MAX(Customer[NewCustomerID) = 1
)
The result are not correct

How do I translate it to DAX?
Thanks,

Oded Dror

[CNENFRNL · Accepted solution]

Table = 
CALCULATETABLE(
    FILTER(
        DISTINCT( Customer[CustomerID] ),
        CALCULATE( MAX( Customer[NewCustomerID] ) ) = 1
    ),
    EOMONTH( Customer[CreatedDT], 0 ) = DATE( 2022, 1, 31 )
)

[Oded-Dror]

You are Super Duper - It works
Thanks,

Oded Dror

One more question how do I display this value in a matrix for each row?