Graphs Last 3 Months

[Chandrashekar]

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

[amitchandak]

@Chandrashekar , Check these two

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

https://bielite.com/blog/last-12-months-from-selected-date-trailing-12-months-ttm/

[Chandrashekar]

Hello Amit,

I got the solution and I missed to click drill down button.

Regards,

Chandrashekar B

[Chandrashekar · Accepted solution]

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

[Chandrashekar]

Hello Amit,

Can you please share pbix file as cannot able to download from link provided.

Regards,

Chandrashekar B

[Chandrashekar]

Hello Amit,

Thanks will check on it.

Regards,

Chandrashekar B