Creating the DAX formula to use the previous value in the other column

[Anonymous]

Hello everyone

I'm trying to create the backlog column as follows:

Backlog (OpenTicket + pre_week to backlog)- CloseTicket

I know the Backlog 2 per week (24 Feb - 1 Sea )

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

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

Thank you 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-Y...

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

Can you share sample data and sample output.