Forum Discussion

NaCl-y's avatar
NaCl-y
Frequent Visitor
8 years ago
Solved

DAX Help needed

Hello all,   I have a problem with the DAX formula. I tried to see where my logic is wrong but i cannot find it. The formula is the following,  LPRD In Advance = CALCULATE(COUNTA(SAP_Transaction_Z...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    8 years ago

    Hi NaCl-y,

     

    Please pay attention to the highlighted part.

    LPRD In Advance =
    CALCULATE (
        COUNTA ( SAP_Transaction_ZP26[LPRD] ),
        FILTER (
            SAP_Transaction_ZP26,
            SAP_Transaction_ZP26[PDCL].[MonthNo] = MONTH ( TODAY () )
                && SAP_Transaction_ZP26[PDCL].[Year] = YEAR ( TODAY () )
                && SAP_Transaction_ZP26[LPRD] < SAP_Transaction_ZP26[PDCL]
                && SAP_Transaction_ZP26[LPRD] <> DATE ( 1900, 1, 1 )
        )
    )
        + 0

     

    Regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi NaCl-y,

 

Please pay attention to the highlighted part.

LPRD In Advance =
CALCULATE (
    COUNTA ( SAP_Transaction_ZP26[LPRD] ),
    FILTER (
        SAP_Transaction_ZP26,
        SAP_Transaction_ZP26[PDCL].[MonthNo] = MONTH ( TODAY () )
            && SAP_Transaction_ZP26[PDCL].[Year] = YEAR ( TODAY () )
            && SAP_Transaction_ZP26[LPRD] < SAP_Transaction_ZP26[PDCL]
            && SAP_Transaction_ZP26[LPRD] <> DATE ( 1900, 1, 1 )
    )
)
    + 0

 

Regards,

Yuliana Gu