I'm trying to show the differences between two releases in power BI.
But it seems it's very difficult to do this, because I'm not getting daily a new release.
I try to solve this by creating a formula minimum and maximum scheduled qty's, and make delta of it, but then I can select only two releases and no more.
Also the headers off course is not showing the date when the release are created.
Does somebody now how I can create this?
Hi Johan,
Hard to imagine how your data looks like and how you get that release, whatever that release means (is it a replacement of the old data, or a new file added into a folder, or a new range of data).
Without a clear description and a sample data structure, hard to answer your question.
Hello Catalin,
What I wanted is are the following,
Below you see the example, we get customer releases and I wanted to compare the demands.
In excel it's each, you make a pivot table and deduced today min yesterday and so one.
But can you get the same result in Power BI ?
Partnumber A
Customer: XXX
Release date 01/06/2021 02/06/2021 difference 04/06/2021 difference
shipping date / demand / difference
05/06/2021 100 150 +50 150 0
07/06/2021 100 100 0 200 +100
09/6/2021 100 100 0 0 -100
15/6/2021 150 100 -50 100 0
17/6/2021 160 180 +20 200 +20
Is the above sample exactly how the source data looks like? Looks more like the desired output, rather than source data.
Hey Catalin, this is indeed the result I want. I will add the file were my data is coming from.