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
wdx223_Daniel's avatar
wdx223_Daniel
Icon for Community Champion rankCommunity Champion
5 years ago

space83 dose it work to change ALL to ALLSELECTED?

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

Hi wdx223_Daniel ,

After I look in deep, my data is not correct. For duplicate Order No and Status Date it will show once. Thus create a running no will not solve the problem.

 

I just use the syntax below and I got result i want which is total of order for 1 interval date.

 

Total Order No = COUNT(OrderIntake[Order No])

 

 

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Icon for Community Champion rankCommunity Champion
    5 years ago

    space83 DAX can not know which one is first if all the columns is identical.