Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Date diffs in the same column

Hi Everyone,   I have a dataset where I am trying to calculate the user response time to dealer note using the note date of every action.   Here is my sample data look like, I've calculated this ...
@Dax Measure Error
DAX
DAX Calculation
DAX Commands
  • dedelman_clng's avatar
    dedelman_clng
    5 years ago

    Hi Anonymous  - 

     

    Try this measure.  The ALLEXCEPT inside the filter "disconnects" from the original Query1 table, causing the error message you are seeing.

     

    DealerNoteDate =
CALCULATE (
    MIN ( Query1[Note Date] ),
     KEEPFILTERS ( Query1[incident] ),
     FILTER (
        Query1,
        Query1[Action Type] IN { "DLR_CUST_Update" }
    )
)

     

    Hope this helps

    David

dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous  - 

 

Try this measure.  The ALLEXCEPT inside the filter "disconnects" from the original Query1 table, causing the error message you are seeing.

 

DealerNoteDate =
CALCULATE (
    MIN ( Query1[Note Date] ),
     KEEPFILTERS ( Query1[incident] ),
     FILTER (
        Query1,
        Query1[Action Type] IN { "DLR_CUST_Update" }
    )
)

 

Hope this helps

David