Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ariass
New Member

SUM IF to DAX

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.

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

1 REPLY 1
Greg_Deckler
Super User
Super User

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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.