Power Platform Community Forum Thread Details

Hello,

Here is my situation: I have a model-driven application on which each entry have a status; let's say as the example below:

Entries	Status
Product A	X
Product B	Y
Product C	Y
Product D	X
Product E	Z

Over time, the status changes, but I want to to keep tracking the ''inventory movements'' so I can each period of time calculate the delta (changes, movement) between these periods. Example:

Time Periods	Count of X	Count of Y	Count of Z
Period 1	2	2	1
Period 2	3	1	1
Period 3	2	1	2

The end result I'm looking for is the following:

Time Periods	X	Y	Z
Period 1
Period 2	+1	-1	0
Period 3	-1	0	+1

I'm building this report in Power BI, that doesn't allow time snapshots, that's why I'm looking for guidance here.

Thanks in advance for any help!

Categories:

Microsoft Dataverse with Power Apps

Hi @Fuser411,

In Dataverse you could have a transactional table that is related to product table that you could store the status over time. This table would be a 1:N relationship from the product table. I would utilize a workflow to create this record on create of the product record and status change of the Product record. This way you could have the following on this related table:

PRODUCT STATUS. CREATE DATE/TIME

Product A X 2021-06-01 10:30:15

Product A Y. 2021-06-02 11:15:10

Product B X 2021-06-02 12:11:16

Your Power BI report could use this table to then look at number of records in specific status over time.

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew