How to build a comparison table who shows the difference between newest data and old data?

[Lennart_IV]

Hello Guys,

I have the following task: I should make a table, who shows the diff between our newest "forecast data" and the old one, like "100.000 profit growth" etc. The Problem is, I found a lot of videos on youtube which show how to build this with fix periods, like comparison by day, week, month or year, but NOT by irregular periods. Just to make sure: every time, we ubload our new data we ubload ALL Data with the current freeze date in the column. That means, that Power Bi has to compare all data with the current freeze date with the data from the last freeze date OR a freeze data of my choice ( would be good If I can decide this with a slicer).

I hope you can help me or give me a hint.

[v-jayw-msft · Accepted solution]

Hi @Lennart_IV ,

You could create two independent date slicer tables.

Then calculated the [profit] based on different slicers.

For example:

forecast_new =
CALCULATE (
    SUM ( 'table'[profit] ),
    FILTER (
        ALLSELECTED ( 'table' ),
        'table'[date] >= MIN ( 'slicer1'[date] )
            && 'table'[date] <= MAX ( 'slicer1'[date] )
    )
)

forecast_old =
CALCULATE (
    SUM ( 'table'[profit] ),
    FILTER (
        ALLSELECTED ( 'table' ),
        'table'[date] >= MIN ( 'slicer2'[date] )
            && 'table'[date] <= MAX ( 'slicer2'[date] )
    )
)

At last, create a measure like below to show the difference.

diff =
( [forecast_new] - [forecast_old] ) & " profit growth"

If I misunderstood your meaning, please show some sample data and expected result.

Best Regards,

Jay