Forum Discussion

RMV's avatar
RMV
Helper V
8 years ago
Solved

datesadd(datesmtd) issue

Hi,   I have a calculated column to get the total amount in a month from last year from a transactional table, to be compared with the MTD figure in the current year in a visual. The formula appli...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    8 years ago

    Hi,

     

    Try this measure (not a calculated column formula)

     

    =CALCULATE(SUM('Transation'[Amount]),SAMEPERIODLASTYEAR(DateCalendar[Date]))

     

    Does this work?

     

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
8 years ago

Hi,

 

Try this measure (not a calculated column formula)

 

=CALCULATE(SUM('Transation'[Amount]),SAMEPERIODLASTYEAR(DateCalendar[Date]))

 

Does this work?

 

 

  • RMV's avatar
    RMV
    Helper V
    8 years ago

    Hi Ashish_Mathur,

    I got the problem. It's because of the data.

    Sorry to bother you.

    Thanks anyway. I will keep in mind your suggestion next time.

     

     

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      8 years ago

      You are welcome.

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      8 years ago

      RMV,

       

      To help close this thread, you may accept solution. Your contribution is highly appreciated.