Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Converting SQL into DAX

Can anyone help me to convert below SQL into DAX? " SELECT * FROM VW_PTP_NC_PHASE WHERE VW_PTP_NC_PHASE[NC Number]         IN (SELECT VW_PTP_NC_PHASE[NC Number]             FROM VW_PTP_NC_PHASE...
  • OwenAuger's avatar
    OwenAuger
    3 years ago

    Hi there,

    Here is how I would translate this to a DAX query:

    EVALUATE
VAR NC_Number_Filter =
    CALCULATETABLE (
        VALUES ( W_PTP_NC_PHASE[NC Number] ),
        VW_PTP_NC_PHASE[Workflow Phase Name] = "Closed"
    )
RETURN
    CALCULATETABLE ( VW_PTP_NC_PHASE, NC_Number_Filter )

    Where are you intending to use this?

    There may be other considerations depending on the context, but essentially the same code should work elsewhere, such as in a measure.

     

    Regards

devanshi's avatar
devanshi
Helper V
3 years ago

 Dax format =   FILTER( VW_PTP_NC_PHASE,
                                     CONTAINS( VALUES(VW_PTP_NC_PHASE[NC Number]),
                                                          CALCULATETABLE( VALUES(VW_PTP_NC_PHASE[NC Number]),                                                                 VW_PTP_NC_PHASE[Workflow Phase Name] = "Closed" ), VW_PTP_NC_PHASE[NC Number]                                        )
                             )