Forum Discussion
Helper ICannot Convert value of type text to type true false
Hi lgs1983 ,
The test you are making is returning a text value, not a true false value. Now if you could frame it so that is Lookupvalue(CIS[CompanyID]) = x, then it can evaluate that. You will probably end up using && for multiple tests, or you could try ISBLANK(). But your test needs something to evaluate.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielHi lgs1983 ,
You may want to try ISBLANK()
Checks whether a value is blank, and returns TRUE or FALSE. The function surrounds the value you are testing.
However BLANK() returns a blank.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielSyntax
DAXCopyISBLANK(<value>)Parameters
Term Definitionvalue The value or expression you want to test. Return value
A Boolean value of TRUE if the value is blank; otherwise FALSE.
Community ChampionHi lgs1983 ,
The test you are making is returning a text value, not a true false value. Now if you could frame it so that is Lookupvalue(CIS[CompanyID]) = x, then it can evaluate that. You will probably end up using && for multiple tests, or you could try ISBLANK(). But your test needs something to evaluate.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Helper IThanks Nathaniel_C , it was me taking it for granted it would see the lookup as a true or false automatically, now amended to the following and works:
IF(
LOOKUPVALUE(CIS[companyID],CIS[DUNSNUM],GUODataCombine[DUNS],CIS[CompanyName],GUODataCombine[PartyName]) = BLANK(),
"Found",
"Not Found")
)- Nathaniel_C
Hi lgs1983 ,
You may want to try ISBLANK()
Checks whether a value is blank, and returns TRUE or FALSE. The function surrounds the value you are testing.
However BLANK() returns a blank.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
NathanielSyntax
DAXCopyISBLANK(<value>)Parameters
Term Definitionvalue The value or expression you want to test. Return value
A Boolean value of TRUE if the value is blank; otherwise FALSE.
- lgs1983
Great, thank you.