Forum Discussion
Solved
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 ...
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
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
