Forum Discussion

RMV's avatar
RMV
Icon for Helper V rankHelper 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
Icon for Helper V rankHelper 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.

 

 

v-chuncz-msft's avatar
v-chuncz-msft
Icon for Community Support rankCommunity Support
8 years ago

RMV,

 

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