Need Help with Dax

shahrukhgaffar0 

Cumulative Value =
VAR CurrentDate = MAX('Dim_Calendar'[Date])
RETURN
CALCULATE(
SUMX(
Sales_Data,
COALESCE(
SWITCH(
TRUE(),
Sales_Data[CRV_Q4_Date] <= CurrentDate, Sales_Data[CRV_Q4],
Sales_Data[CRV_Q3_Date] <= CurrentDate, Sales_Data[CRV_Q3],
Sales_Data[CRV_Q2_Date] <= CurrentDate, Sales_Data[CRV_Q2],
Sales_Data[CRV_Q1_Date] <= CurrentDate, Sales_Data[CRV_Q1],
Sales_Data[AwardDate] <= CurrentDate, Sales_Data[Contract Value],
0
),
0
)
),
Sales_Data[AwardDate] <= CurrentDate
)

Relate Dim_Calendar[Date] → Sales_Data[AwardDate]

Bar chart: X-axis = Dim_Calendar[Month-Year], Y-axis = [Cumulative Value]

Year slicer on Dim_Calendar[Year]

If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande