Forum Discussion
YesP
Helper I
1 year agoCreate a measure Current while filtering various month (YDT)
Hi, I have a visualization with YTD and Same Period Last Year. I want to create a measure to get the Actuals of the last Month of the YTD. For instance: I have Data from January to Decmber 13. My fi...
- 1 year ago
Hi,
Try this measure
Measure = calculate([Current],datesbetween(Calendar[date],eomonth(max(calendar[date]),-1)+1,max(calendar[date])))
Hope this helps.
YesP
Helper I
1 year agoAshish_Mathur this works great. Thank you!
Ashish_Mathur
Super User
1 year agoYou are welcome.