Forum Discussion
Delta Calculation for Duplicated row dates
hello every body ...
i have this table with duplicate rows for date column
i want to calculate the Delta for "Deaths" only ? like a Measure
plz help me guys
country date status values previos date
| Spain | 04/16/2020 | 395.570224334054 | Recovered | 04/15/2020 | |
| Spain | 04/16/2020 | 395.570224334054 | Active | 184948 | 04/15/2020 |
| Spain | 04/16/2020 | 395.570224334054 | Delta_Confirmed | 7304 | 04/15/2020 |
| Spain | 04/16/2020 | 395.570224334054 | Deaths | 19315 | 04/15/2020 |
| Spain | 04/15/2020 | 379.948293204569 | Recovered | 04/14/2020 | |
| Spain | 04/15/2020 | 379.948293204569 | Active | 177644 | 04/14/2020 |
| Spain | 04/15/2020 | 379.948293204569 | Delta_Confirmed | 5103 | 04/14/2020 |
| Spain | 04/15/2020 | 379.948293204569 | Deaths | 18708 | 04/14/2020 |
You can try a new column like
Diff = [values] - maxx(filter(Table,[country] =earlier([country]) && [status] =earlier([status]) && [date] =earlier([date]) -1),[Value])
This will diff between same status
3 Replies
You can try a new column like
Diff = [values] - maxx(filter(Table,[country] =earlier([country]) && [status] =earlier([status]) && [date] =earlier([date]) -1),[Value])
This will diff between same status
thank you sooo much it was like a magic 😙
can you give an explanation how the formula work
Hi,
What's in the third column? There is no title there. Please show the exact expected result.
