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