Forum Discussion
Classic workspace Usage Metric - Trend View calculation
Happy New Year everyone! I need a help on customised Power BI usage metric report. I am using live connection to Usage Metrics dataset (classic workspace)for my customized usage report, and I...
amitchandak
Super User
Super UserMikeKKK , Try with this change
View Trend =
VAR StartDate = MINX(allselected(Dates) ,Dates[Date])
VAR EndDate = MAXX(allselected(Dates) ,Dates[Date])
VAR PeriodHalfDaysCount = INT((MAX(Dates[Date])-MIN(Dates[Date]))/2)
VAR MidDate = StartDate+PeriodHalfDaysCount
VAR FirstHalfView = CALCULATE([ViewsCount], DATESBETWEEN(Dates[Date],StartDate,MidDate))
VAR SecondHalfView = CALCULATE([ViewsCount], DATESBETWEEN(Dates[Date],MidDate+1,Enddate))
RETURN DIVIDE (SecondHalfView-FirstHalfView,FirstHalfView)
amitchandak I can see you have changed the Variable StartDate and EndDate , how does this help?