find daily value

[ybatistamayo]

my dataset contains a column with cumulative values, by region and date and i want to get daily values

https://drive.google.com/open?id=1XNu1PY7fnyeQVKkmwgPsKTan-tugKmOv

I Want something like this

[v-kelly-msft]

Hi @ybatistamayo ,

You need a calculated column as below:

Column = 
var a =CALCULATE(MAX('Data'[Cumulative Value]),FILTER('Data','Data'[Date]=EARLIER(Data[Date])-1),'Data'[Region]=EARLIER(Data[Region]))
Return
IF('Data'[Date]=MINX('Data','Data'[Date]),'Data'[Cumulative Value],'Data'[Cumulative Value]-a)

Finally you will see:

For the related .pbix file,pls click here.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak · Accepted solution]

@ybatistamayo , Please find the attached file after the signature. Create a new column.