Forum Discussion
Different Periods in same Line Chart starting from the same point
Panto , you need to have a date table connected with your table and another disconnected date table. The first formula will consider period 1 which on date table. As it joined you Measure will work
Measure = Calculation<>....
The second period will come from the disconnected table Date1, we will not use this in join just move the date
new measure =
var _min = minx(allselected(Date),Date[Date])
var _min1 = minx(allselected(Date1),Date[Date])
var _diff = datediff(_min1,_min,Day) // You may have try datediff(_min,_min1,Day)return
calculate([measure], dateadd(Date[Date],_diff,day))
Panto , you need to have a date table connected with your table and another disconnected date table. The first formula will consider period 1 which on date table. As it joined you Measure will work
Measure = Calculation<>....
The second period will come from the disconnected table Date1, we will not use this in join just move the date
new measure =
var _min = minx(allselected(Date),Date[Date])
var _min1 = minx(allselected(Date1),Date[Date])
var _diff = datediff(_min1,_min,Day) // You may have try datediff(_min,_min1,Day)
return
calculate([measure], dateadd(Date[Date],_diff,day))
Hi amitchandak
thanks for your quick feedback: that makes sense.
Propbably I was too focused on replicating the same logic used in another tool via parameters and didn't think about your idea which seems really what I'm looking for.
Have a nice day
Fabio
Hi,
I was trying to replicate this scenario with no success. What do you plot on the Axis to have same measure charted for different periods?
