Forum Discussion

Panto's avatar
Panto
Helper I
6 years ago
Solved

Different Periods in same Line Chart starting from the same point

Hi community,   I'm dealing with time intelligence functions and I'm facing a challenge when it comes to let the final user selecting 2 different time periods with the final result that should be v...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    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))

v-easonf-msft's avatar
v-easonf-msft
Community Support
6 years ago

Hi ,  Panto 
Not very clear.Maybe I need a bit more information.

Please explain this phrase in more detail:" even though the 2 periods have different lenghts (in terms of days) and starting dates, they are somehow aligned for the first 16 days"

It seems that the four parameters do not correspond to the picture you show?

 

You may check if the following pbix helps:

pbix attached

 

Best Regards,
Community Support Team _ Eason