Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! 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})))
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 10 | |
| 9 | |
| 7 | |
| 7 |