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

gokmengineer 1 Reputation point
2020-06-03T02:22:56.11+00:00

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.
36,252 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dave Patrick 426.1K Reputation points MVP
    2020-06-03T02:47:41.23+00:00

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

    https://community.powerbi.com/

    --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