cancel
Showing results for
Did you mean:
Frequent Visitor

## 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!

3 REPLIES 3
Super User II

Hi @Wilm117 -

Unless I'm misunderstanding the question, you may just be over thinking it.  If you use Date Created as the column, Post as the rows, and SUM(geboekt bedrag) as the values it won't accumulate the sums over the entire table.

If you're meaning something else, please expand on what you are trying to accomplish.

Hope this helps

David

Proud to be a Super User!

Frequent Visitor

Hi Dedelman_clng,

Thanks for your reply. Maybe i was not clear enough in my explanation. I see your point, however, in this case i am only interested in the difference in the amount of money (Geboekt Bedrag) between every period (date created). Using "date created as column gives me a perfect overview on the total amount of "geboekt bedrag" eacht period, but how much more money is spend compared to the previous period.

Now i make seperate calculations like:

Calculate(table1''[geboekte kosten]) , 'table1'[index] = "2") - Calculate(table1''[geboekte kosten]) , 'table1'[index] = "1")

i did this for each following period, but i would like to find a way how i can automatically calculate the added amount to the column "geboekte kosten" for each period.

Does this make it more clear?

Super User II

Hi @Wilm117 -

Here is a new column getting the value from the previous period, and then a measure to calculate (and display the difference.

``````PrevPd =
VAR __Idx = [index]
VAR __Post = [post]
RETURN
LOOKUPVALUE (
Geboekt[geboekt bedrag],
Geboekt[index], __Idx - 1,
Geboekt[post], __Post
)
``````

``````Delta =
IF (
ISBLANK ( SUM ( Geboekt[PrevPd] ) ),
BLANK (),
SUM ( Geboekt[geboekt bedrag] ) - SUM ( Geboekt[PrevPd] )
)
``````

Hope this helps

David

Proud to be a Super User!

Announcements

#### 2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

#### Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

#### Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Top Kudoed Authors