Forum Discussion
Dynamic row number by date
Slap another RANKX computation onto your original rank, make it ascending and add 7.
Thanks for the reply, I don't necessarily need it to start on 8 just as long as the numbers are consecutive but I'm not sure what I should be using for the expression in the RANKX?
I've tried this but just getting 1's all the way down.
Please provide sanitized sample data that fully covers your issue.
Please show the expected outcome based on the sample data you provided.I found the answer here Solved: Dynamic Row Numbers - Microsoft Power BI Community
However, I realised it needs to be a measure and the whole idea of it for me was to return row context as I have another measure that looks back n number of rows to return the value. So I don't think it can be done.
don't forget the new functions - WINDOW - OFFSET - INDEX
- Introducing DAX Window Functions (Part 1) – pbidax (wordpress.com)
- INTRODUCING DAX WINDOW FUNCTIONS (PART 2) – pbidax (wordpress.com)