I can help you achieve this please can you share a sample workbook so I can see the structure of your data and deduce the best method for your scenario
Hi Suresh have a look at the file attached
I have calculated the required for one of your measures using 2 different methods
Method 1 is to create 2 new measures Current Period and Previous Period for each Measure
The second is to check if the date falls in the range selected and in the comparison range day, week, month , year
using the 2 filters with either method you can do comparison to previous day , previous week, previous month or previous year.
The method of creating a measure for current period and previous period is more flexible as it makes it easier to calculate variances as I have demonstrated.
Let me know if you have any further questions or require any further assistance.
It worked like a charm Khalid !! saved my day, thanks a ton for your help !!