Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Calculate sum based off dates

Hello all! 

 

I'm trying to create a formula that will sum a colum of sales, but by a date range.

 

Both columns are in the same table together. But need to be summed in a custom column/measure for different reasons.

 

one coulmn has sales and one has dates in this format 10/1/2020

 

My current formula is 

October Savings = CALCULATE(SUM(vwProjTracker[glbl_m_net_val]),vwProjTracker[Rep Month]=10/1/2020)
 
This gives me nothing back though.
 
Any help would be great!
 
Thank you!
Need Help
  • parry2k's avatar
    parry2k
    5 years ago

    Anonymous assuming Rep Month data type is the date and then you need to change your measure like this

     

    October Savings = 
CALCULATE(
SUM(vwProjTracker[glbl_m_net_val]),
vwProjTracker[Rep Month]=DATE(2020,10,1)
)

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Anonymous assuming Rep Month data type is the date and then you need to change your measure like this

     

    October Savings = 
CALCULATE(
SUM(vwProjTracker[glbl_m_net_val]),
vwProjTracker[Rep Month]=DATE(2020,10,1)
)