How to display current and previous value in dashboard

[RAKESH1986]

Hi All,

I want to display the current and previous week's values as a value selection 

whenever the user selects any week in the slicer it should display that selection value plus the previous value.

this value OF PW02 should come in the above the previous week whenever the user selects PW03.

These are my value in these three columns...

good to have both the previous and current week in the one table...in my example, I added current and previous in two different table because I do not know how to add them in the same table and display

this is my table having above used three column  

pls, tell me the simplest way to do this, I am very new to powerbi

[RAKESH1986]

@amitchandak  Thanks for response, its too comlicated for me to udnerstand, i am very new to power bi and i am not a developer. if you do not mind can u take my column name as example and show me how to do it?

thanks

rakesh

[amitchandak]

@RAKESH1986 , You need a week rank column in separate week or date table

Week Rank = RANKX(all('Date'),'Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX(all('Date'),'Date'[Year Week],,ASC,Dense) //YYYYWW format

These measures can help
This Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])))
Last Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Week Rank]=max('Date'[Week Rank])-1))

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s

Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
https://www.youtube.com/watch?v=pnAesWxYgJ8