topic Re: Subtracting values up column databases in DAX Commands and Tips

Subtracting values up column databases

matrix_user — Sun, 12 Feb 2023 03:42:58 GMT

Hello,

What DAX measure (or column) would be required if I wanted to count the difference in values within a column of a fact table - per year?

Below the subtract of 8 (2021) from 5 (2010) gives me 3.

Kudos to who can help.

Thank!

Re: Subtracting values up column databases

Jihwan_Kim — Sun, 12 Feb 2023 04:46:48 GMT

Hi,

Please check the below picture and the attached pbix file.

It is for creating a measure.

Diff: = VAR _previousvalue = CALCULATE ( [Total coffees:], OFFSET ( -1, ALL ( Data[Year] ), ORDERBY ( Data[Year], ASC ) ) ) RETURN IF ( NOT ISBLANK ( _previousvalue ) && HASONEVALUE ( Data[Year] ), [Total coffees:] - _previousvalue )

Re: Subtracting values up column databases

matrix_user — Sun, 12 Feb 2023 05:26:39 GMT

Fantastic!