Forum Discussion

tkavitha911's avatar
tkavitha911
Icon for Helper III rankHelper III
1 year ago
Solved

urgent help needed

AdjustedArrivalDate1 = VAR ETA = MAXX(     FILTER(Inbound_Query, NOT(ISBLANK(Inbound_Query[Max of ETA]))),     Inbound_Query[Max of ETA] ) VAR ClearanceDays = MAX(Inbound_Query[Clearence day...
urgent help needed
  • BA_Pete's avatar
    BA_Pete
    1 year ago

    Hi tkavitha911 ,

     

    You don't need to declare the table name in an X-Function as you're iterating over a virtual table that you've created, not the actual base table.
    Try deleting the table reference here:

     

     

    Pete

     

mdaatifraza5556's avatar
mdaatifraza5556
Icon for Super User rankSuper User
1 year ago

Hi tkavitha911 

The error you are seeing,,,,,,,,,,,,,,,,,,,,,,,typically means there is a problem with the DAX syntax, or misplaced commas, parentheses..


Ensure that 
1. Column name, measure and table are correctly written.

 

If still getting issue then 
1. Then test the each var separately.

If this answers your questions, kindly accept it as a solution and give kudos.