Change in values from one date to the next for a matrix

[LFM]

Hi. How can I calculate the change of values from one day to the next in this matrix? I want a similar matrix like this, just that I replace the values of required margin with values that show change from the previous day. I also hope it can show values that skip the weekends.

[LFM]

Thanks for your answer. I also wonder, do you know how to do it if you sort the dates decending instead, it seems like the values doesnt change correspondly. And is it possible to make change PD in another table than values?

[lbendlin]

See attached.  You can hide columns that are needed in the visual calculation but shhould not be displayed. if you want the dates sorted descending you need to use NEXT instead of PREVIOUS in your formula.

[v-kongfanf-msft]

Thanks for the reply from @lbendlin , please allow me to provide another insight:

Hi @LFM ,

You can try formula like below:

MEASURE =
IF (
    MAX ( 'Table'[Column] ) = BLANK (),
    BLANK (),
    SUMX (
        FILTER (
            ALL ( 'Table' ),
            'Table'[Column] <= MAX ( 'Table'[Column] )
                && YEAR ( 'Table'[Column] ) = YEAR ( MAX ( 'Table'[Column] ) )
        ),
        [Value]
    )
)

Best Regards,
Adamk Kong

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

[lbendlin]

You can use regular measures, or you can use Visual Calculations (via PREVIOUS).  

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[LFM]

Thanks for reply. Sorry for my late answer. I want to create a table like the second table shown under in PBI. The second table shows the change from a day to the next from the first table. It shows value at this current day - value of previous day. 

Required Margin

Row Labels	2024	2025	2026	2027	2028	Grand Total
13.02.2024	-   22 542 633	-   16 837 240	-  12 768 355	-  18 042 881	-      3 743 291	-    73 934 400
12.02.2024	-   22 021 893	-   15 726 715	-  12 970 967	-  18 296 180	-      3 594 315	-    72 610 070
15.02.2024	-   21 495 132	-   17 002 583	-  13 750 170	-  17 669 510	-      3 496 271	-    73 413 666
16.02.2024	-   22 520 425	-   17 006 291	-  13 999 709	-  18 185 899	-      3 761 547	-    75 473 871
19.02.2024	-   21 459 403	-   16 750 154	-  13 789 290	-  18 073 870	-      5 775 828	-    75 848 545
20.02.2024	-   21 187 919	-   16 993 396	-  13 894 589	-  18 094 580	-      5 790 503	-    75 960 987
21.02.2024	-   21 568 956	-   17 085 024	-  13 951 712	-  18 171 540	-      5 812 173	-    76 589 405
22.02.2024	-   13 114 460	-   16 721 141	-  12 849 968	-  15 991 985	-      5 948 417	-    64 625 971

Change from previous day

	2024	2025	2026	2027	2028	Grand Total
13.02.2024	-        609 667	8 430	1 093 376	-       332 914	-         241 788	-           82 563
12.02.2024	520 740	1 110 525	-       202 612	-       253 299	148 976	1 324 330
15.02.2024	526 761	-     1 275 868	-       779 203	626 670	98 044	-         803 596
16.02.2024	-     1 025 293	-            3 708	-       249 539	-       516 389	-         265 276	-      2 060 205
19.02.2024	1 061 022	256 137	210 419	112 029	-      2 014 281	-         374 674
20.02.2024	271 484	-        243 242	-       105 299	-         20 710	-           14 675	-         112 442
21.02.2024	-        381 037	-          91 628	-         57 123	-         76 960	-           21 670	-         628 418
22.02.2024	8 454 496	363 883	1 101 744	2 179 555	-         136 244	11 963 434

[lbendlin · Accepted solution]

Note: I unpivoted your source data to bring it into usable format.