Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
THENNA_41
Post Partisan
Post Partisan

Generate Number series in calculated column based other column number change

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.

 

1 REPLY 1
amitchandak
Super User
Super User

@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

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.