Hi All,
The data mart am working on has both daily and monthly data , where the month end data is the sum of all the daily data and the last day of the month. Calculating YTD at Month end date, adds the whole month.
Kindly assist in either
MDX query to manipulate
a. If I select non month end date, it should do the YTD base on the selected date.
b. If I select month end date, it should do the YTD base on the month end date.
Many thanks.