Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Difference from previous date aggregate on graph

Hello world,  I have made this calculation to obtain some specific data Unapp = CALCULATE(COUNT('Dim - Sales'[AR Id]),filter('Fact - Receipts','Fact - Receipts'[AR Status]=="UNAPP")) and I crea...
Need Help
Show and Tell
Tips and Tricks
v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi Anonymous ,

 

You could add two fields in x-axis: Year and your date column. Then use ISINSCOPE() function to show the result.

[Sum] is the result of every month, [Measure] is the difference from previous year.

Measure =
VAR a =
    CALCULATE (
        SUM ( 'Table'[Value] ),
        FILTER ( ALLSELECTED ( 'Table' ), 'Table'[YEAR] = MAX ( 'Table'[YEAR] ) - 1 )
    )
RETURN
    IF ( ISINSCOPE ( 'Table'[Date] ), [SUM], [SUM] - a )

Here is my test file for your reference.