Forum Discussion

PowerBINoobie's avatar
PowerBINoobie
Regular Visitor
9 years ago
Solved

Dynamic Status Based on Multiple Date Columns

Hello, I am fairly new to PowerBi and hoping someone can help me with a problem I have been having.  I have PartsTable with a Start Date, Process Date, Shipped Date, and Status columns. I also hav...
  • v-chuncz-msft's avatar
    v-chuncz-msft
    9 years ago

    PowerBINoobie,

     

    You may create a measure as shown below.

    Measure =
VAR d =
    MIN ( 'Calendar'[Date] )
RETURN
    SWITCH (
        TRUE (),
        ISBLANK ( MAX ( PartsTable[Process Date] ) )
            || MAX ( PartsTable[Process Date] ) > d, "Started",
        ISBLANK ( MAX ( PartsTable[Shipped Date] ) )
            || MAX ( PartsTable[Shipped Date] ) > d, "Processing",
        "Shipped"
    )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
9 years ago

PowerBINoobie,

 

You may create a measure as shown below.

Measure =
VAR d =
    MIN ( 'Calendar'[Date] )
RETURN
    SWITCH (
        TRUE (),
        ISBLANK ( MAX ( PartsTable[Process Date] ) )
            || MAX ( PartsTable[Process Date] ) > d, "Started",
        ISBLANK ( MAX ( PartsTable[Shipped Date] ) )
            || MAX ( PartsTable[Shipped Date] ) > d, "Processing",
        "Shipped"
    )