Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello there,
I need a calculated column "Result" to be filled up with the immediate previous row value as shown below.
Any suggestions please? PS: Do not want this to be a measure value, so may be this could be returned as a table output which can act like a temporary table. There are additional calculations lined up on top of this output.
ID | Date | Rank | Result ( Immediate Previous Date based on Rank for each ID) |
1 | 01/01/2021 | 2 | |
1 | 02/01/2021 | 1 | 01/01/2021 |
2 | 01/01/2021 | 3 | |
2 | 03/01/2021 | 2 | 01/01/2021 |
2 | 05/01/2021 | 1 | 03/01/2021 |
Thanks,
Pravallika
Solved! Go to Solution.
@Anonymous
Add the following calculated column to your table:
Result =
var __currentrank = Table11[Rank]
var __currentid = Table11[ID]
var result =
MAXX(
FILTER( Table11 , Table11[ID] = __currentid && Table11[Rank] = __currentrank + 1 ),
Table11[Date]
)
return
result
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@Anonymous
Add the following calculated column to your table:
Result =
var __currentrank = Table11[Rank]
var __currentid = Table11[ID]
var result =
MAXX(
FILTER( Table11 , Table11[ID] = __currentid && Table11[Rank] = __currentrank + 1 ),
Table11[Date]
)
return
result
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |