Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

KPI comparing dates different tables

Hi,   I want to compare 2 date columns in different tables, which are connected with a production number.   I'd like to create a KPI for this. I visualized it in a table already to see if product...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

The issue might be that e.g. the actual date table has e.g. 5 entries for production number 1 while the planned date table has only 1 entry for production number 1. This is due to scanning equipment (start, stop, breaks etc) which is in the actual date table, but not in the planned date table.

 

I want to compare the planned date with the last actual date of the same production number

  • v-janeyg-msft's avatar
    v-janeyg-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi, Anonymous 

     

    You can try like this:

    a =
IF (
    OR (
        MAXX ( 'Planned Production', 'Planned Production'[Planned End date] )
            > MAXX ( 'Actual Production', 'Actual Production'[Actual End Date] ),
         (
            MAXX ( 'Planned Production', 'Planned Production'[Planned End Date] )
                = MAXX ( 'Actual Production', 'Actual Production'[Actual End Date] )
        )
    ),
    1,
    0
)

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.