Forum Discussion

Chandrashekar's avatar
Chandrashekar
Icon for Resolver III rankResolver III
4 years ago
Solved

Graphs Last 3 Months

Hello Team,

 

I was looking video(https://www.youtube.com/watch?v=d8Rm7dwM6gc) where we get last 6 months graph.

 

However in (14:49) they used Tabular Editor for calculation. Is it possible to get result without using Tabular Editor.

 

Kindly assist on the same.

 

Regards,

Chandrashekar B

  • Chandrashekar's avatar
    Chandrashekar
    4 years ago

    Hello Amit,

     

    I tried below measure but still it is showing 1 month rather than 3 months.

    Last previous 12 month =
    var date_max=maxx(ALLSELECTED(Date2),Date2[Date_created])
    var date_min =date(year(date_max),month(date_max)-3,day(date_max))+1
    Return
    calculate(count(Source[number]),filter('date','date'[Date_created]<=date_max &&
    'date'[Date_created]>=date_min))
     

     

     
    Regards,
    Chandrashekar b

5 Replies