Forum Discussion
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 bu...
lbendlin
Super User
Super UserNearly 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"))