topic Custom column / measure to find today's change in DAX Commands and Tips

Custom column / measure to find today's change

ashah2020 — Fri, 31 Jul 2020 04:33:20 GMT

Hi All,

I am new to Power BI and DAX, wanting to achieve below mentioned 3rd column using DAX. Any help on this highly appreciated.

Date	Population	Daily Change
01-01-2020	100	100 (since no previous date)
02-01-2020	300	200 (300 - 100)
03-01-2020	500	200 (500 - 300)

Any help woul dbe highly appreciated. Thanks!

Re: Custom column / measure to find today's change

amitchandak — Fri, 31 Jul 2020 04:56:53 GMT

ashah2020 , This will give change . you can create text column on that

new colum =
var _date = maxx( filter(Table,[date] <earlier([date])),[Date])
return
[Population] - maxx( filter(Table,[date] = _date)),[Population])

// prefer this if you continuous date

new colum =
[Population] - maxx( filter(Table,[date] = earlier([date])-1),[Population])

Re: Custom column / measure to find today's change

Anonymous — Fri, 31 Jul 2020 11:30:07 GMT

Hi ashah2020 ,

Incase you want a measure

Change = VAR _prevdate = MAXX ( FILTER ( ALL ( 'Table' ), 'Table'[Date] < MAX ( 'Table'[Date] ) ), 'Table'[Date] ) RETURN IF ( _prevdate = BLANK (), 0, SUM ( 'Table'[Population] ) - CALCULATE ( SUM ( 'Table'[Population] ), FILTER ( ALL ( 'Table' ), 'Table'[Date] = _prevdate ) ) )

Regards,
Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)