1 of 1 people found this helpful
Try creating a calculated field with this code:
DATEDIFF('day', [Date], #8/30/2013#)
You'll probably want to drag the field you create from measures to dimensions. You can also right click the field and change it to discrete if you want headers instead of an axis.
Your formula works wonders but what if I want to look at all these 30 days in between as a count leading upto that 1 day. for example I tried your formula and tweaked a little bit so it looks like this :-
From this you will know that it gives me one single count of 30 days in the view but now I want to see those 30 days counting backwards 30,29.28.........1. Is there a way to do that. Am I missing something or does this question make sense?
Really appreciate your quick reply. You're awesome.
Reason for me to have a count up to the last day possible i.e. 30,29,28,27........all the way to 1 is because my vizz will show a clear picture of the data that I want to present right to the day instead of 30 or 32 days out.
This is what I was talking about, this small tweak of 30-datediff gives exactly what I want.
Thank you Shawn for your expertise.