Forum Discussion

space83's avatar
space83
Icon for Helper IV rankHelper IV
5 years ago

add running no column via direct query

Below is example of my report.   How can I create new virtual column and display running no of the record?   it will auto count.   Please dont tell me using 'add column > index' since it wi...
Need Help
Show and Tell
Tips and Tricks
space83's avatar
space83
Icon for Helper IV rankHelper IV
5 years ago

Hi wdx223_Daniel ,

Now it works. I am using below formula. Thanks for your help.

No = VAR _order =
    MAX ( OrderIntake[Order No] )
VAR _date =
    MAX ( OrderIntake[Status Date] )
RETURN
    COUNTROWS (
        FILTER (
            SUMMARIZE ( ALLSELECTED ( OrderIntake ), OrderIntake[Order No], OrderIntake[Status Date] ),
            ISONORAFTER ( OrderIntake[Order No], _order, , OrderIntake[Status Date], _date, ASC )
        )
    )