What is the correct method to calculate the sales percentages in respective quarter?

gokmengineer 1 Reputation point

For the first data of the table, it should be calculated as 5,893,082 / 26,520,122.00 = 22.22% but the measure doesn't bring the QTD (Quarter-To-Date) amount to the denominator.
What is the suggested solution to calculate the sales percentages in the respective quarter? Is there a time-intelligence formula to calculate this? Is this related to weighted average per category percentage? 9022-percentage-of-sales-by-quarter.png

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
27,175 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 354.1K Reputation points MVP

    Power Bi is not currently supported here on QnA. I'd try asking for help in dedicated forums here.


    --please don't forget to Accept as answer if the reply is helpful--

    Regards, Dave Patrick ....
    Microsoft Certified Professional
    Microsoft MVP [Windows Server] Datacenter Management

    Disclaimer: This posting is provided "AS IS" with no warranties or guarantees, and confers no rights.

    0 comments No comments