Forum Discussion
AGo
Post Patron
9 years agoConverting DAX to Power Query M language in the query editor
Column =
CALCULATE (
MAX ( Table1[date] ),
FILTER (
ALL ( Table1 ),
EARLIER ( Table1[product ID] ) = Table1[product ID]
&& EARLIER ( Table1[date] ) <= Table1[date...
dchager
9 years agoRegular Visitor
Read www.daxpatterns.com to find a more efficient DAX formula.