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

=VAR _order=MAX(Table[Order No]) VAR _date=MAX(Table[Status Date]) RETURN COUNTROWS(FILTER(SUMMARISE(ALL(Table),Table[Order No],Table[Status Date]),Table[Order No]<_order&&Table[Status Date]<_date))+1

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

Hi wdx223_Daniel,

What is this? where should I put this snippets? New column, New measure?

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

    space83  it's a measure, create a new measure with that code, then drag it into the visual.