Trending - taking the values form the first half of the filter and comparing to the second half

DAX
3

Hi @chad.sharpe - I have come up with this but not sure how to manage missing dates as of now.

Test Measure1 =

VAR First_Date = firstdate('EDNA Report Views'[Date_Viewed])

VAR Last_Date = LASTDATE('EDNA Report Views'[Date_Viewed])

VAR Days_Between = QUOTIENT(countrows(DATESBETWEEN('EDNA Report Views'[Date_Viewed], First_Date, Last_Date)),2)

var firstrows = CALCULATE([Total Views],DATESINPERIOD('EDNA Report Views'[Date_Viewed],First_Date,Days_Between,DAY))

var LastRows = CALCULATE([Total Views],DATESINPERIOD('EDNA Report Views'[Date_Viewed],Last_Date,-Days_Between,DAY))

Return LastRows - firstrows

eDNA Trending.pbix (25.7 KB)

Thanks
Ankit J

1 Like