Forum Discussion
Dynamic row number by date
Hi, I have a dense rank over the date column so that all dates have the same row number regardless of however the data is sliced, in this example it is by gender: However, if I then filter...
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)