Forum Discussion
PrathSable
Advocate II
6 years agoDivide previous row by next row
Hi Guys, I have the following data set: Date Keyword Count 01-01-2020 ABCD 5 01-01-2020 DEFG 2 01-01-2020 HIGK 3 01-01-2020 LMNO 0 01-01-2020 PQRS 3 01-01-2020 ...
speedramps
Super User
6 years agoHi Prath
Please consider this solution
Either by using Query Group By or DAX table functions do the following
Create a “now” subset of your original table with just the latest value per keyword.
Create a “remainder” subset of your original table with all records except the records on the above subset.
Create a “before” subset of your “remainder” table with just the latest value per keyword.
You can now report “now” - “before” by keyword.