Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

IFERROR

Hi All,   I am trying to use the IFERROR in DAX.    This is the formula I have used for Recommended Daily Usage Type.   Recommended Daily Usage Type = IFERROR(LOOKUPVALUE('Daily Usage Type'[Pr...
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Anonymous ,

     

    then that's not an error. You can check if it's blank to return the Usage Type and otherwise the lookup value.

    Try the following measure:

    Recommended Daily Usage Type =
VAR vLookupValue =
    LOOKUPVALUE(
        'Daily Usage Type'[Proposed Daily Usage],
        'Daily Usage Type'[PartPlantbyYearWeekNum], 'Master Data Hygiene (2)'[PartPlantbyYearWeekNum]
    )
RETURN
    IF(
        vLookupValue = BLANK(),
        'Master Data Hygiene (2)'[Daily Usage Type],
        vLookupValue
    )

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     

     

ChrisMendoza's avatar
ChrisMendoza
Icon for Resident Rockstar rankResident Rockstar
5 years ago

Possibly you're not getting an error because an 'error' is not occurring in the LOOKUP

 

If there's no match that satisfies all the search values, BLANK or alternateResult (if supplied) is returned. In other words, the function won't return a lookup value if only some of the criteria match.

 

https://docs.microsoft.com/en-us/dax/lookupvalue-function-dax#return-value

Maybe try putting something in the optional <alternateResult>