Compare periods of data uploads (not necesarrily dates)
Hi everybody! I am working on a report and I present the amount of money spend per period using this graph and the table underlyint this graph: This is pretty straigthforward, but i am looking for a way to only visualize the amount of money spend per period instead of the cumulative of everything. As a quick solution i made seperate measures, where i manually subtracked Gebbedrag2 - Gebbedrag1 etc. The results are shown the following table. However, it is difficult to make a nice visual with this and it will take manual work everytime i update this report. Does somebody know the right formulas to get to this point, without having to make new measures everytime i upload something? Underneath i posted a table with a simplified version of the data i use. index date created post geboekt bedrag 1 7-1-2021 material 2510841 1 7-1-2021 staff 6528437 1 7-1-2021 overhead 131079 1 7-1-2021 food 35334 2 29-1-2021 material 2543553 2 29-1-2021 staff 6528437 2 29-1-2021 overhead 131079 2 29-1-2021 food 35334 3 8-3-2021 material 2596334 3 8-3-2021 staff 6528437 3 8-3-2021 overhead 137673 3 8-3-2021 food 35334 4 7-4-2021 material 2655314 4 7-4-2021 staff 7738437 4 7-4-2021 overhead 143647 4 7-4-2021 food 35334 Thanks!
