Cumulative total for Particular type.

Anonymous — Mon, 15 Jun 2020 12:55:20 GMT

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")))

Re: Cumulative total for Particular type.

lbendlin — Mon, 15 Jun 2020 15:44:42 GMT

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"))

topic Re: Cumulative total for Particular type. in DAX Commands and Tips

Cumulative total for Particular type.

Re: Cumulative total for Particular type.