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?

     

     

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.