Forum Discussion

frankly's avatar
frankly
Frequent Visitor
3 years ago

Row differences using DAX (PowerBI)

¿What would be the simplest DAX formula in PowerBI to calculate row differences?   I tried using EARLIER() but it cannot handle the operation at the limit (missing data): EARLIER/EARLIEST refers t...
Need Help
ERD's avatar
ERD
Community Champion
3 years ago

Hi frankly ,

You can try this measure:

 

diff =
VAR _current_row = SELECTEDVALUE ( Table_[row] )
VAR _current_value = SELECTEDVALUE ( Table_[value] )
VAR _prev_row = MAXX ( FILTER ( ALL ( Table_[row] ), Table_[row] < _current_row ), Table_[row] )
VAR _prev_value = MAXX ( FILTER ( ALL ( Table_ ), Table_[row] = _prev_row ), Table_[value] )
RETURN
    IF ( NOT ISBLANK ( _prev_value ), _current_value - _prev_value )

 

+

For the calculated coumn:

Column =
VAR _current_row = Table_[row]
VAR _current_value = Table_[value]
VAR _prev_row = MAXX ( FILTER ( VALUES ( Table_[row] ), Table_[row] < _current_row ), Table_[row] )
VAR _prev_value = MAXX ( FILTER ( Table_, Table_[row] = _prev_row ), Table_[value] )
RETURN
    IF ( NOT ISBLANK ( _prev_value ), _current_value - _prev_value )