Forum Discussion

DanCasSan's avatar
DanCasSan
Icon for Helper V rankHelper V
6 years ago
Solved

Disaggregate accumulated

Hello community.   How could I get the highlighted field? What happens is that I have the accumulated information per day, but I need to know the value of the day. I have attached an example table....
Interesting Links
Need Help
Tips and Tricks
Tutorial Requests
  • az38's avatar
    az38
    6 years ago

    Hi DanCasSan 

    try a column

    Column = 
var _prevDate = CALCULATE(MAX(Table[Date]), FILTER(ALL(Table), Table[CountryName] = EARLIER(Table[CountryName]) && Table[Date] < EARLIER(Table[Date]) ) )
var _thisVal = EARLIER(Table[ValueAccuum])
RETURN
_thisVal - CALCULATE(MAX(Table[ValueAccuum]), ALLEXCEPT(Table, Table[CountryName]), Table[Date] = _prevDate )
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi DanCasSan ,

 

Check out this blog.

 

You can get the previous date and value in the same row and then subtract the value of the columns

 

http://harshnathani.blogspot.com/2020/06/find-previous-details-of-customer-in.html

 

 

 

Column =

 

var PreviousDate =

CALCULATE (

    MAX ( 'Table'[Date] ),

    FILTER (

        ALLEXCEPT (

            'Table',

            'Table'[CountryNam]

        ),

        'Table'[Date]

            < EARLIER ( 'Table'[Date] )

    )

)

 

var _rankOrder = RANKX(FILTER('Table', 'Table'[CountryNam] = EARLIER('Table'[CountryNam])),'Table'[Date],,ASC)

 

var PreviousValAcum =

CALCULATE (

    MAX('Table'[ValueAcum]),

    FILTER (

        ALLEXCEPT (

            'Table',

            'Table'[CountryNam]

        ),

        'Table'[Date]

            < EARLIER('Table'[Date])  && 'Table'[Rank Date] = _rankOrder - 1

    )

)



return

'Table'[ValueAcum] - PreviousValAcum

 

 

Regards,

Harsh Nathani