Forum Discussion

InsightSeeker's avatar
InsightSeeker
Helper III
2 years ago
Solved

DAX Query Assistance Required

Hello - I need to add a condition to the following DAX formula. Could you provide any suggestions?   ```DAX If Table 2_Check = Location or Place then check LEN('TABLE_1'[From_Sector] ) = 3 && LE...
  • ryan_mayu's avatar
    2 years ago

    it's better to provide some sample data and expected output.

     

    based on the coding you provided

     

    If Table 2_Check =" Location" || Table 2_Check ="Place", if xxxx

     

    and there is something wrong with the last part

    LEN('TABLE_1'[Code] ) = 2 &&
    "Valid","Error")