Hi Hari, I am trying to calculate YTD, QTD, MTD and 7TD from given parameter. I am able to achieve the no.of days in YTD, MTD etc but I am unable to filter the measure value for the particular period in iif clause. As date field is not in table context. Could you please provide me some insights on the same?
Hi Hari, Thanks for detailed information. How to get data for last day of the week, let's say one month has 04 weeks and want to get on Sundays data. What will be the formula to get Sunday's date