Forum Discussion

Martin_Leneman's avatar
Martin_Leneman
Regular Visitor
5 years ago
Solved

Need help with incorrect totals

Hi all, I could use some help here.. I want to make a calculation regarding stock values changes between months. Here is the scenario.: Stock values are stored every 1st day of the month. The first ...
Need Help
  • Martin_Leneman's avatar
    Martin_Leneman
    5 years ago

    Hi all,
    think I got lost in a far to complex approach... After looking at this issue with a fresh mind i figured a simple use of dateadd must do the trick. And sure it did... 

    Stock Value EOM DateAdd = CALCULATE( [StockValue Start of Month], DATEADD( 'Date'[Date], +1, MONTH ) )

    I use this formula all the time somehow i overcomplicated this  
    Thanks for your contributions! 

Martin_Leneman's avatar
Martin_Leneman
Regular Visitor
5 years ago

Hi all,
think I got lost in a far to complex approach... After looking at this issue with a fresh mind i figured a simple use of dateadd must do the trick. And sure it did... 

Stock Value EOM DateAdd = CALCULATE( [StockValue Start of Month], DATEADD( 'Date'[Date], +1, MONTH ) )

I use this formula all the time somehow i overcomplicated this  
Thanks for your contributions! 

v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi Martin_Leneman ，

 

Also thanks for your sharing.

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!