Forum Discussion

NavaneethaRaju's avatar
NavaneethaRaju
Helper IV
4 years ago
Solved

Assigned date and Order date issue(Need Measure)

Hi Team,   I need a advice and need measure or calculated column to find the details.   Requirement- I have consigned(assigned) date on particular tagID, that tagID has been used after some days....
Need Help
Show and Tell
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    Hi， NavaneethaRaju ；

    You could create a measure .

    Measure = IF( MAX('Table'[Order Date])=BLANK(),DATEDIFF(MIN('Table'[Consigned Date]),TODAY(),DAY),DATEDIFF(MIN('Table'[Consigned Date]),MAX('Table'[Order Date]),DAY))

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
4 years ago

NavaneethaRaju , Try a new measure line

 

minx(filter(allselected(Table), Table[Tag ID] = max(Table[Tag ID])), [Order Date]) - maxx(filter(allselected(Table), Table[Tag ID] = max(Table[Tag ID])), [consigned Date])