I am very new to MDX. I have the sales amount measure and date dimension.
I need two measure sales value for the below condition. I am going to display this result in SSRS.
For between from date and todate
For last week range
Can you please help me to solve this issue?