dax calculations

[Anonymous]

Hi Team...

I need help in creating a measure which will calculate delta difference of employee batch comparing its value to previous day. Also when i put it on a line chart visual with the date field having hierarchy of day\week\month, the new delta column should sum up to it.

Calculated column does not sum up for week or month though it shows the day week delta trend correctly.

Below is my example data:

Expected out put on line chart:

[Icey]

Hi @Anonymous ,

Is this problem solved?

Best Regards,

Icey

[Icey]

Hi @Anonymous ,

How do you create your "new delta column"? What about creating a [Rank] measure insteading of using an Index column?

Best Regards,

Icey

[Anonymous]

Hi Icey,

I get the delta column from the database, but it shows correct values only for day, not for month and week. Will try creating using rank measure.