March 3, 2021
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?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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
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)