Forum Discussion

InsightSeeker's avatar
InsightSeeker
Icon for Helper III rankHelper 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 &&
LEN('TABLE_1'[To_Sector] ) = 3 &&
DATEVALUE('TABLE_1'[DepDate]) &&
DATEVALUE('TABLE_1'[ArrDate]) &&
'TABLE_1'[Basis] <> BLANK() &&
LEN('TABLE_1'[Rbd] ) = 1 &&
LEN('TABLE_1'[Code] ) = 2 &&
'TABLE_1'[Miles] <> BLANK(),
"Valid",

If Table 2_Check = Non-Location then check
IF(
LEN('TABLE_1'[From_Sector] ) = 3 &&
LEN('TABLE_1'[To_Sector] ) = 3 &&
DATEVALUE('TABLE_1'[DepDate]) &&
DATEVALUE('TABLE_1'[ArrDate]) &&
LEN('TABLE_1'[Rbd] ) = 1 &&
LEN('TABLE_1'[Code] ) = 2 &&
"Valid","Error")

 

Thanks

 

 

Need Help
Show and Tell
  • ryan_mayu's avatar
    ryan_mayu
    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")

     

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    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")