Log In
Register
Home
March 3, 2021
Offline
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?
November 8, 2013
Offline
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.
March 3, 2021
Offline
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
1 Guest(s)
