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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

Any reason you didn't "and" that condition to your other conditions?

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

If you are talking about the  SAP_Transaction_ZP26[LPRD] <> DATE(1900,1,1), it is because that gives me an error shown below. 

 

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

    Try changing your <> to >