News and Announcements icon

Dynamics 365 CommunityForums Business Central forum Order to quote convers...

Business Central forum

Suggested answer

Order to quote conversion data DAX filter query for Power BI

(0) Share

Report

Report

Posted on by arijeetacharyya

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.

salesOrders have the column orderDate and salesQuotes have documentDate.

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

Categories:

Reports and Business Intelligence

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

MahGah 15,419 on at

Like (0)

Report

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 228,501 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans