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...
HotChilli's avatar
HotChilli
Icon for Community Champion rankCommunity 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?