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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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
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?
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
10 | |
7 | |
5 | |
4 | |
3 |
User | Count |
---|---|
12 | |
11 | |
9 | |
9 | |
8 |