Mkrish
Ten Centuries
Points: 1256
More actions
October 28, 2014 at 12:12 am
#291439
i have an report
where i have to calculate last month data only
how i can achieve this....can any one suggest me.....
Koen Verbeeck
SSC Guru
Points: 259105
October 28, 2014 at 1:49 am
#1755109
The easiest solution is that you have a column in your time dimension that indicates the last month. Then you can simply filter on that column.
Need an answer? No, you need a questionMy blog at https://sqlkover.com.MCSE Business Intelligence - Microsoft Data Platform MVP
October 28, 2014 at 3:34 am
#1755130
is it not possible to handle it using mdx query
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply