Forum Discussion

Digger99's avatar
Digger99
Regular Visitor
3 years ago

EDATE

I am trying to use a subtract measure to form the months part of the EDATE function, this number can vary depending on whats in the other columns. For example, I'm trying to work out when to purchase the product, so I'm minusing Lead Time from Stock on Shelf

1 Reply

  • HotChilli's avatar
    HotChilli
    Community Champion
    3 years ago

    If it's a measure you want, you will need aggregations in front of each column.

    I suggest you experiment with the EDATE part removed and just get 'the number of months' on a visual to test.

    Also I don't follow the accuracy of the provided Order Date column. Can you explain how you got that?