Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to Solution.
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
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
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 >
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |