I need to calculate a measure which will always give me the most up todate value (the max date) for the NAV divided by the NAV on the a number of date ranges eg the last month, the last 3 months, the last year. I am trying to calculate the % between any of these two periods. The data is set out below. Thanks in advance.
Hi Phil, I copied this over to my model and the measure isn't producing any results. If I have to include Year to date and since inception could you explain what alternations I need to make to your measure
Hi Ashish, I am struggling a bit to implement your solution which works for periods like 1 month, 3 months or 12 months but how could I factor in Year to date and since inception calculations using your model.