Forum Discussion
Chandrashekar
Resolver III
Resolver IIIGraphs 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 g...
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))+1Returncalculate(count(Source[number]),filter('date','date'[Date_created]<=date_max &&'date'[Date_created]>=date_min))Regards,Chandrashekar b
amitchandak
Super User
Super UserChandrashekar , 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/
ChandrashekarHello Amit,
Thanks will check on it.
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,
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))+1Returncalculate(count(Source[number]),filter('date','date'[Date_created]<=date_max &&'date'[Date_created]>=date_min))Regards,Chandrashekar b - Chandrashekar
Hello Amit,
I got the solution and I missed to click drill down button.
Regards,
Chandrashekar B