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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
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.