Forum Discussion
Getting the next order month
Anonymous add a new column using following DAX code:
Next Order Date = VAR __table = FILTER ( ALLEXCEPT( 'Order', 'Order'[Customer ID] ), 'Order'[Order Status] IN { "Processing", "Complete" } ) VAR __currentDate = 'Order'[Order Date] VAR __nextOrderDate = CALCULATE ( FIRSTDATE ( 'Order'[Order Date] ), __table, 'Order'[Order Date] > __currentDate ) RETURN __nextOrderDate✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Anonymous add a new column using following DAX code:
Next Order Date =
VAR __table = FILTER ( ALLEXCEPT( 'Order', 'Order'[Customer ID] ), 'Order'[Order Status] IN { "Processing", "Complete" } )
VAR __currentDate = 'Order'[Order Date]
VAR __nextOrderDate = CALCULATE ( FIRSTDATE ( 'Order'[Order Date] ), __table, 'Order'[Order Date] > __currentDate )
RETURN __nextOrderDate
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks, had to make a slight tweak but it worked (the IN function wasn't working for some reason or other so I used
||. Thanks!