Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

SUM Based on FIELD Date Range

Hi there, I am having some trouble getting the results required. Any help would be much appreciated. REVENUE = Currency Field QUOTED = Date September 2021 = Calendar Date   I am trying to...
General Comment
Need Help
Tips and Tricks
Tutorial Requests
  • Ashish_Mathur's avatar
    Ashish_Mathur
    4 years ago

    Hi,

    Create a Calendar Table with a replationship from the Date column of the 2 tables to the date column of the Calendar Table.  Create Year, Month Name and Month number columns in the Calendar Table.  Sort the Month name column by the Month number column.  To your visual, drag Year and Month name columns from the Calendar Table.  Write this measure:

    Total revenue = sum(Data[Revenue])

    Hope this helps. 

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
4 years ago

Hi,

Create a Calendar Table with a replationship from the Date column of the 2 tables to the date column of the Calendar Table.  Create Year, Month Name and Month number columns in the Calendar Table.  Sort the Month name column by the Month number column.  To your visual, drag Year and Month name columns from the Calendar Table.  Write this measure:

Total revenue = sum(Data[Revenue])

Hope this helps.