title: How to use filter when creating calculated column in Power BI?
body: <p>Filter cannot be used in calculated columns, then how can I simply create a column in DAX that would pick up a value based on maximum <code>claimID</code> and maximum <code>DateCreated</code> ?</p>
  
  <p><a href="https://i.stack.imgur.com/YPKQp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YPKQp.png" alt="enter image description here"></a></p>
  
  <p><strong>The result should be like this:</strong></p>
  
  <p><a href="https://i.stack.imgur.com/pt4mz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pt4mz.png" alt="enter image description here"></a></p>