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"
    )
brianheath's avatar
brianheath
New Member
4 years ago

Hi.. I am trying to replicate this for my own particular use but it does not seem to be updating.

I have created and linked the calander table and entered the code as proposed, but it seems to only pick up the first status regardless. Have I missed an important step somewhere?

Any pointers/suggestions or alternative ideas would be greatly valued.. 

Thanks in advance 

Brian