I wanna plot results by month marks on x-axis where the months are calculated from days between two different dates
Eg: Date 1 = 6/24/2016 and Date 2 = 6/29/2016
Formula for Calculated Measure called Month Mark = DATEDIFF('day',[Date 1],[Date 2])
This gives me 5
I can create 30 day bins for Month Mark but that would make my x-axis show 30 days, 60 days etc. (I can create for 30 days=1 month alias for each value but that's tedious)
I want my x-axis to not say 0 days, 30 days, 60 days etc. but 1,2,3 months.. etc.
So 5 would fall in month 1. 35 would fall in month 2. And so on.
Does this work?
DATEDIFF('day',[Date 1],[Date 2])/30
and BIN by "1"