This can be done by creating a calculated field similar to the following:
if attr([Order Date])=total(max([Order Date])) then 1
elseif attr([Order Date])=total(min([Order Date])) then 1
Place the date field on the Columns shelf and and the above calculation on the rows shelf. Make sure the calculation is set to Discrete. Then, right click on it and select Compute Using-->Table (Across). Right click on it and select Filter. Select only 1. If desired, right click on the calculation again and un-check Show Header.
Hope this helps!
1 of 1 people found this helpful
You could apply the 'date' field once more as a filter. Drag it to the 'Filters' shelf again and select 'Individual dates and times', hit 'Next', and tick 'Use all'. Then show this newly created Filter as a 'quick filter', when it appears on the right-hand side, open its menu and select 'only relevant values'. This list only shows you the dates from the date range filter, and you can easily select the first and last date. The two days should be displayed in the format you wanted. (the date field needs to be on the columns shelf for that as well)
Maybe this works as well for you,
Thank you very much for your help.
That works exactly how I expact. But now I have the next challenge. I want to calculate the difference between the measure of the last date and the first date.
My approach was to create a calculated field with: LOOKUP(sum([DailyPageEngagedUsers]), last() ) - LOOKUP(sum([DailyPageEngagedUsers]), first() ).
It calculates the difference but it comes up twice if I drag it to the measurebox, one time for each date.
Do you have one further hint for me?
One more Point: If i display the sum of the columns i got all dates back ...