Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hey everyone,
I'm trying to create a column that gets me the amount of phone calls since the last sale for each sales rep. I have a table with a Rep column and Date of Last Sale column. I'm having an issue trying to sum from my phone call table only if the Date of Call is after the Date of Last Sale. My thought was to create a measure using sumif and then a column in the Sales Rep table based off that measure. SUMIF(Date of Call,>Date of Last Call,Phone Call Count) would be my formula in excel but I need help going to DAX.
Solved! Go to Solution.
Generally the answer to SUMIF questions is CALCULATE. So, something like:
Measure = CALCULATE(SUM(Table[Column]),FILTER(...))
The FILTER essentially becomes the "IF" portion of your SUMIF.
Generally the answer to SUMIF questions is CALCULATE. So, something like:
Measure = CALCULATE(SUM(Table[Column]),FILTER(...))
The FILTER essentially becomes the "IF" portion of your SUMIF.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
126 | |
106 | |
105 | |
86 | |
72 |