% difference between current abd previous month in a matrix table

[UditJ]

Need to add a column next to march called -  % diff which will calcualte the difference between the current and previous months for all the values as shown in the below image : 

[Anonymous · Accepted solution]

Hi @UditJ ,

Please have a try.

Create the following format.

% Diff =
DIVIDE (
    [Current Month Value]
        - CALCULATE ( [Current Month Value], PREVIOUSMONTH ( 'Table'[Date] ) ),
    CALCULATE ( [Current Month Value], PREVIOUSMONTH ( 'Table'[Date] ) )
) * 100

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.