Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
can someone help me converting my dax code to Custom column/M code in power query
Time =
Suppose the data is sorted by Rank
NewStep=Table.AddColumn(YourTable,"Time",Function.ScalarVector(Value.Type(each _),(t)=>let a=List.Buffer(YourTable[#"TableWithRank.ACTION_DATE"]) in List.Transform(List.Positions(a),each if _=0 then null else Duration.TotalMinutes(a{_}-a{_-1})))
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.