Index List using direct query SQL Database

[Mike5049]

Hi All,

I'm trying to generate an index for all the rows in my data set in an effort to display a running total where the date has been subdivided into day and nightshift. I assume because I have subdivided the days the existing running totals aren't calculating correctly and I can't think of how else to calculate the running total unless I have an index column to refer too? 

Problem is that I am using an SQL Database with direct query - so I can't use power query to generate an index column.

Any thoughts would help.

[Anonymous · Accepted solution]

Hi @Mike5049 ,

I made simple samples and you can check the results below:

Rank = var _t = ADDCOLUMNS('Table',"Rank",RANKX(ALL('Table'),[Total],[Total],DESC,Dense))
RETURN MAXX(_t,[Rank])

An attachment for your reference. Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Change the date format from 4/12/23, Day to 2023-04-12, Day  .  Then you can sort it alphabetically.