Forum Discussion

peterlyngvig's avatar
peterlyngvig
Regular Visitor
3 years ago

Last twelve months

Hi,   In the table below, I have presented some monthly cost data - each data represents the sum of the various costs items for each month. The input data is a spreadsheet with credit card transact...
AnkitKukreja's avatar
AnkitKukreja
Icon for Super User rankSuper User
3 years ago

Hi peterlyngvig 

 

You can try something like this.

Last 12 Months=
CALCULATE (
   [Total Sales],
   DATESINPERIOD (
      'Date'[Date],
      MAX ( 'Date'[Date] ),
      -12,             
      MONTH                 
    )

 

  • peterlyngvig's avatar
    peterlyngvig
    Regular Visitor
    3 years ago

    Thanks Ankit.

     

    I tried your solution, but I am getting the error message "A single value for column 'Cost' in table 'Sheet1' cannot be determined". See below. What is wrong here? Your help is much appreciated 🙂