cancel
Showing results for
Did you mean:
Frequent Visitor

## 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_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`

It follows this data table.

On my Dashboard, i have these

In the formula, I specifically said to not include the date of 1900/01/01 of LPRD, however it counts it. "LPRD In Advance" should be 2 instead of 3.

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: DAX Help needed

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 REPLIES 4
Super User

## Re: DAX Help needed

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

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Frequent Visitor

## Re: DAX Help needed

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

Super User

## Re: DAX Help needed

Try changing your <> to >

### I have book! Learn Power BI from Packt

Proud to be a Datanaut!

Super Contributor

## Re: DAX Help needed

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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 311 members 3,376 guests
Recent signins: