Forum Discussion
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_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.
Thanks in Advance!
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 )
)
)
+ 0Regards,
Yuliana Gu
4 Replies
Any reason you didn't "and" that condition to your other conditions?
If you are talking about the SAP_Transaction_ZP26[LPRD] <> DATE(1900,1,1), it is because that gives me an error shown below.
Try changing your <> to >
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 )
)
)
+ 0Regards,
Yuliana Gu
