Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Everyone !
I am quite new to power bi and im facing an issue when im creating new measure , this is my DAX formula
Solved! Go to Solution.
Is this what you meant?
Completion =
IF(
AND(
VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24]),
VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24])
),
TRUE,
FALSE
)
When using AND(), a comma is used to separate the 2 clauses instead of &&. It could also be written as:
Completion =
IF(
VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24])
&& VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24]),
TRUE,
FALSE
)
(I didn't try to fix anything else.)
Hi @butterscotch
Adding to @gmsamborn
Use simple && in DAX
Completion =
IF(
VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24]) &&
VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24]),
TRUE,
FALSE
)
Thank you guys, it helps to resolve the issue by adding VALUES()
Hi @butterscotch
Adding to @gmsamborn
Use simple && in DAX
Completion =
IF(
VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24]) &&
VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24]),
TRUE,
FALSE
)
Is this what you meant?
Completion =
IF(
AND(
VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24]),
VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24])
),
TRUE,
FALSE
)
When using AND(), a comma is used to separate the 2 clauses instead of &&. It could also be written as:
Completion =
IF(
VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24])
&& VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24]),
TRUE,
FALSE
)
(I didn't try to fix anything else.)
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |