Challenge: Find out new records from last update

[uie07923]

Hi Colleagues!

I have a report that is downloaded in every working day.

It brings a list of materials and records of alerts (like risks of shortages, MRP exceptions).

The question asked every day is: "what are the items that had new messages or increases from the last update to today?"

What we do is a pivot table and manually identify these (as per example above).

How can I make this identification in Power BI?

[AlB · Accepted solution]

@uie07923 

Try this measure:

Measure =
VAR currentDate_ =
    SELECTEDVALUE ( Table1[Data Report] )
VAR prevDate_ =
    CALCULATE ( MAX ( Table1[Data Report] ), Table1[Data Report] < currentDate_ )
VAR currentVal_ =
    COUNT ( Table1[Data Report] )
VAR prevVal_ =
    CALCULATE ( COUNT ( Table1[Data Report] ), Table1[Data Report] = prevDate_ )
VAR diff_ = currenVal_ - prevVal_
RETURN
    IF ( diff_ > 0, diff_ )

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.

[uie07923]

Something like this:

The pivot table is just a Count of lines:

[AlB]

Hi @uie07923 

Can you show a sample of the underlying table that you use for the pivot? and an example of the calculation based on that data?

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.