Forum Discussion
Creating a new value based on previous row
Hello, Trying to figure this one out. I have this working in Excel, but want to migrate to using an active SQL Server connection. In the Excel version, I have the Calculated value Weeks Ou...
Anonymous,
You can create the following columns in your table.Rank = RANKX(FILTER(Table1,Table1[JoinCol]=EARLIER(Table1[JoinCol])),Table1[TransWeek],,ASC,Dense)
Column = CALCULATE(FIRSTNONBLANK(Table1[Rank],1),NOT(ISBLANK(Table1[Meeting Week 0])),ALLEXCEPT(Table1,Table1[JoinCol]))
Weeks Out Sales Meeting = var tempvalue=Table1[Rank]-Table1[Column] return IF(tempvalue>=0,tempvalue,BLANK())
Regards,
Lydia
Anonymous
Follow up to this. What changes need to be made to reset the Row/Column counters when a second Week 0 Meeting occurs for the same Join Col value? I've been trying a few things, but my limited knowledge of PBI & DAX are hindering my efforts.
Anonymous,
Please open a new thread with sample data and expected result.
Regards,
Lydia