Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Digger99
Regular Visitor

EDATE

‎03-08-2023 04:08 AM

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

Message 1 of 2
562 Views
0
1 REPLY 1
HotChilli
Super User
Super User

‎03-08-2023 07:15 AM

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?

Message 2 of 2
505 Views
0

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

View All