Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I want Generate Number based on ther other column first number (1 ) chanage . attached sample input Data for reference
Table
task task number
dd 1
ww 2
qw 3
ty 4
yu 5
if Number 1 changed to 2 order output look like
task task number calcaulted column
dd 2 2
ww 2 3
qw 3 4
ty 4 5
yu 5 6
if Number 1 changed to 3 order output look like
task task number calcaulted column
dd 3 3
ww 2 4
qw 3 5
ty 4 6
yu 5 7
if Number 1 changed to 4 order output look like
task task number calcaulted column
dd 4 4
ww 2 5
qw 3 6
ty 4 7
yu 5 8.
@THENNA_41 , in Power query create and index column and then add a new custom column
List.Max(#"Last Step Table Name"[task number]) + [Index]
or if you need measure try rownumber
Power BI - New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1
add Minx(allselected(Table), Table[Task Number]) to rownumber
User | Count |
---|---|
79 | |
76 | |
68 | |
66 | |
53 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |