Hello. Why do you use (ALL) in this powerpivot formula?
Sum Actuals This Month:=CALCULATE([Sum Amount], FILTER(ALL(Calendar), Calendar[Year #] = MAX(Calendar[Year #])), FILTER(ALL(Calendar),Calendar[Month #] = MAX(Calendar[Month #])))
Hello. Why do you use (ALL) in this powerpivot formula?
Sum Actuals This Month:=CALCULATE([Sum Amount], FILTER(ALL(Calendar), Calendar[Year #] = MAX(Calendar[Year #])), FILTER(ALL(Calendar),Calendar[Month #] = MAX(Calendar[Month #])))
See link below.
http://bfy.tw/6jMV
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks