Creating DAX formula to use previous value from the another column

[Anonymous]

Hi everybody,

I'm trying to create Backlog Column as following:

Backlog= ( OpenTicket + Backlog pre_week )- CloseTicket

I already know that Backlog =2 for week (24 Feb - 1 Mar )

Date	OpenTicket	CloseTicket	Backlog
02-08 Mar	5	2	5
09-15 Mar	4	3	6
16 -22 Mar	6	2	10

Could someone else provide me a solution to this? It would help me a lot.

Thanks in advance,

[amitchandak]

@Anonymous ,

Cumm Sales = CALCULATE([OPen]-[Close],filter(date,date[date] <=maxx(date,date[date])))
Cumm Sales = CALCULATE([OPen]-[Close],,filter(date,date[date] <=max(Sales[Sales Date])))

Or use week Rank, if you do not have Dates

Assume Week table is Date

Cumm Sales = CALCULATE([OPen]-[Close],filter(date,date[Week Rank] <=maxx(date,date[Week Rank])))

How to do

https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-YTD-LYTD-Week-Over-Week/m-p/1051626#M184

Refer, this is on similar topic https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Can you share sample data and sample output.