Forum Discussion

GS_Developer's avatar
GS_Developer
New Member
4 years ago

Order to quote conversion data DAX filter query

I have 2 tables coming from Business Central into Power BI Desktop - Sales Orders and Sales Quotes. Now, we want to get the quote to order conversion data for a specific time duration as per the user...
Need Help
Show and Tell
parry2k's avatar
parry2k
Super User
4 years ago

GS_Developer you should add a calendar dimension in your model, you can follow my blog post here Create a basic Date table in your data model for Time Intelligence calculations | PeryTUS IT Solutions to create one.

 

Have relationship with date dimension to your sales order and quote table, and in visualization use year/month/date from date dimension and count from other two tables and you will get the result

 

 

āœØ Follow us on LinkedIn and  to our YouTube channel

 

Learn about conditional formatting at Microsoft Reactor

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.