Forum Discussion
Shift value in a column by Dax function
Hi all, I would like to know Is there any function in Dax help shift values in a column. For example: Column 1 Column 2 Column 3 1 a a 2 b b 3 c c 4 d d 5 e e 6...
Hello amitchandak ,
I am struggling with this case.
I current ly have a table like this.
| Time | Count | Expected (if shift 3 rows) |
| 01/01/2018 10:00:00 PM | 4 | |
| 01/01/2018 11:00:00 PM | 2 | |
| 02/01/2018 12:00:00 AM | 2 | |
| 02/01/2018 01:00:00 AM | 6 | 4 |
| 02/01/2018 02:00:00 AM | 4 | 2 |
| 02/01/2018 03:00:00 AM | 9 | 2 |
| 02/01/2018 04:00:00 AM | 0 | 6 |
How can I use DATEADD function with this table?
In my topic, you mentioned use
Date = Table[timestamp].date
Could you please help me explain more how to use this?
I want to calculate a count shifted by specific days, just like DATEADD function.
Thank you for your help.
Try like
rank = rankx(all(table),table[Time],,asc,dense)
In the below 2 second one should work
expected = maxx(filter(table,table[rank]=earlier(table[rank])-3),table[count])
//OR
expected = maxx(filter(table,table[rank]-3=earlier(table[rank])),table[count])
Appreciate your Kudos.