Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
Digger99
Regular Visitor

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 1
HotChilli
Super User
Super User

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?

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.