DAX Query Assistance Required

[InsightSeeker]

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

[ryan_mayu · Accepted solution]

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")