Forum Discussion

mespoKTM's avatar
mespoKTM
Regular Visitor
5 years ago

Calculate sum with rolling data filter

I have a measure that calculates the end of the month based on the month selected in a histogram chart. I need to calculate a sum for documents that have as date the period between the beginning of t...
Need Help
Tips and Tricks
mespoKTM's avatar
mespoKTM
Regular Visitor
5 years ago

I'm sorry but your solution doesn't works.

I simply want to calculate the sum of revenue from the start of the year to the end of selected month.

 

Thank you so much!

v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi mespoKTM ，

 

I suggest you use lastnonblank instead of selectedvalue in your formula:

 

99_EOMONTH_SELVALUE = EOMONTH(DATE(YEAR(NOW()),LEFT(LASTNONBLANK(Mesi[Mesi],1),2),01),0)

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai