Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Cumulative total for Particular type.

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

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

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