Forum Discussion
YesP
Helper I
Helper ICreate 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...
Hi,
Try this measure
Measure = calculate([Current],datesbetween(Calendar[date],eomonth(max(calendar[date]),-1)+1,max(calendar[date])))
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Try this measure
Measure = calculate([Current],datesbetween(Calendar[date],eomonth(max(calendar[date]),-1)+1,max(calendar[date])))
Hope this helps.
YesPAshish_Mathur this works great. Thank you!
- Ashish_Mathur
You are welcome.