Cumulative total for Particular type.

[Anonymous]

Hi,

I am new to PowerBI. I have one table where I have enquiry data and sales data. Now I need Cumulative enquiry Data and Cumulative sales data for my report.

I have written one DAX query but it didnot work:

Total Cumulative Enquiry: Calculate(Sum(Value), Filter(Calender, Calender(date)<= Max(Calender(date))) , Filter(CRM, Attribute= "Enquiry")))

[lbendlin]

Nearly there. You'll learn about filter and row context.

For now, use variables

Total Cumulative Enquiry=

var md=selectedvalue(Calendar[date])

return Calculate(Sum(Value), Filter(Calendar, Calendar[date]<= md) , Filter(CRM, CRM[Attribute]= "Enquiry"))