Forum Discussion
butterscotch
Helper II
2 years agoToo few arguments were passed to AND function. the minimum argument count for the function is 2
Hello Everyone ! I am quite new to power bi and im facing an issue when im creating new measure , this is my DAX formula Completion = IF(AND(VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-...
- 2 years ago
Hi butterscotch
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.)
- 2 years ago
Hi butterscotch
Adding to gmsamborn
Use simple && in DAXCompletion = IF( VALUES(Master[Start Date].[Date]) <= VALUES(Master[Jan-24]) && VALUES(Master[End Date].[Date]) >= VALUES(Master[Jan-24]), TRUE, FALSE )
butterscotch
Helper II
2 years agoThank you guys, it helps to resolve the issue by adding VALUES()