I am trying to calculate sum of a measure for last 3 months based on the selected month. I do not have a date table and I am importing the data from SSAS server. Its an import and not a live connection.
I only have a month and year fields for the time. I do not have a date.
Can someone please help?
You should make a standard date table! It reelly helps. Then you can calculate(measure, datesbetween)
I do not want to get date in the query result set when I import the data. The result set is very huge and will take much longer if I get the date as well. Appreciate if you have another suggestion...