Forum Discussion
Get previous row value in table visual
Hi Team,
I have this visual created with VD1 (visualDate1) and RecordID (sum(recordid)).
What i need to get is the preivous row value for each VD1. For example: FY22 W02 should show the previousvalue as 2279.
The VD1 is coming from a "Date" table and RecordID is from "order" table
8 Replies
Anonymous it will be easier if you add a date column or number column to get the previous row. If you don't have a date column, you can easily add an index column in Power Query and that will help to get the previous row.
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k Thanks.
Yes I have the date column in the "Date" table as below. With this, how can i achieve the previous value without showing the Date column in the view.
parry2k I also created the "ranking" column which gives the ranking based on VD1. Now, would it be possible to help me get the previous row value?
So, Fy22 W28, in the below image should show a value of 1208 (which is of Fy22 W29)
Anonymous Is the "VD1" column in the "Date" table?
parry2k Yes "VD1" column is in the Date table
Anonymous did you saw my previous question? You never replied.
parry2k Sorry, I just replied to it.
