Thank you for answering, but this is not what i want.
In your screenshot, how you identify today? maybe you use if....then sum(value) and what's your calculation1:true?
this way can work for a little measures .. but i have plenty of them.
What I want is to first identify the date, so i can directly drag different measures into viz
(like profit, sales, freight, marketing fees etc. I can't create calculated field for each of them.)
and the difficulty is each 'comparison date' only has one 'Day of date' and the measure value of '4 week' also needs to divide by 4
maybe this way can't succeed ... any suggestions？
Thanks for reply.
However this is not what i want.
Please let me know if any alternative is available.
I am confused. Can you explain it a bit more?
In 'comparison date' I have today, yesterday, last week, week before last week and 4 week.
4 week is different from the others because it has 4 dates (Aug 12, Aug 5, July 29 and July 22).
Then I need to add measures like profit, sales and it works well except '4 week'.
As you can see in the 'Day of date', there is only one date (July 22) assigned to '4 week' so does the profit and sales value.
I want the average value of profit/sales for 4 week : (measure value of Aug 12+ Aug 5+ july 29+ July 22) / 4
Hope it is clear for you.
In this case, you need union your data to itself to create a copy for 4 week use only.
If you could share a sample workbook, it will be easier to show how it works