Forum Discussion

butterscotch's avatar
butterscotch
Helper II
2 years ago
Solved

cannot find name

Hello Everyone ! im having a trouble in formula where the column name cannot be found , i have table called Yard Loading that has column "Start Date", but when i put inside the formula, an erro...
Need Help
  • butterscotch's avatar
    butterscotch
    2 years ago

    I already find a solution for my issue, where instead of doing hard code like above, i forget that i can simply use relationship in model view and its done

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi butterscotch ,

 

Please replace MONTH('Yard Loading'[Start Date])  with  MONTH(SELECTEDVALUE('Yard Loading'[Start Date])) 

Or   MONTH(MAX('Yard Loading'[Start Date])) 

 

Replace 'Norm Loading'[Month 1]  with SELECTEDVALUE('Norm Loading'[Month 1])

Or  MAX('Norm Loading'[Month 1])

 

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.