how to calculate difference between max of daily dates?

[Nakul93]

I have a table where the data keeps on incrementing continously, I am able to get max of each day. But what I want to achieve here is total of each day i.e difference of max values between each days. Here is a sample of both raw data and max of cycles per day, please help

[danextian]

Hi @Nakul93,

Try this:

Extract the date part of tts column by creating a calculate column

Date =
INT ( 'Table'[tts] )

Note: This column will be formatted as decimal by default. Change the format to date.

Create a new measure to get the max value per date.

DateMaxValue = 
CALCULATE ( MAX ( 'Table'[Value] ), ALLEXCEPT ( 'Table', 'Table'[Date] ) )

Create another measure to get the difference between two dates

DateMaxDiff = 
VAR __PREV_DAY =
    CALCULATE ( [DateMaxValue_], DATEADD ( 'Table'[Date], -1, DAY ) )
RETURN
    [DateMaxValue_] - __PREV_DAY

[Nakul93]

Hi @danextian,

Your solution worked somewhat but it is now showing data for the future date as well. Just look at the report attached

The data is from 24th june to 2nd july...but it is showing data of july 3rd as well and the value 11169 is the total sum

[danextian · Accepted solution]

Try this formula instead:

DateMaxDiff =
VAR __PREV_DAY =
    CALCULATE ( [DateMaxValue_], DATEADD ( 'Table'[Date], -1, DAY ) )
RETURN
    IF ( NOT ( ISBLANK ( [DateMaxValue_] ) ), [DateMaxValue_] - __PREV_DAY )