Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Suggested answer

Order to quote conversion data DAX filter query for Power BI

Posted on by 10

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 for this data. So currently these 2 tables are connected by their creation dates. I need help creating a DAX query that would count the number of sales quotes created within a specific time period - for example last 1 month and divide it up with the number of orders created within the same period. That way I would be able to get the conversion percentage. 

pastedimage1642274827769v2.png

salesOrders have the column orderDate and salesQuotes have documentDate.

Any help with the filter query would be appreciated. Thanks!

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Order to quote conversion data DAX filter query for Power BI

    Maybe try something like this

    From Modeling -> New measure create 3 new measure one for SalesQuote, one for SalesOrder , one for conversion rate.

    Then use Count formula (something like below) to count Quote and SO (one for each using above measure) . Only use Var if in Quote you want to count SO as part of quote (you use var Quote , then Va SO then you add them together) 

    VAR Quote =
    CALCULATE(
    COUNT ( Sales_Quote[documentDate] ),

    Then for conversion rate use a formula like this in conversion rate measurement 

    Quotes Converted to Sales % =
    DIVIDE ( [SalesOrder], [SalesQuote] )
    I hope this help  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,532 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,501 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans