question

gokmengineer avatar image
0 Votes"
gokmengineer asked ·

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

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-supported
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

DSPatrick avatar image
0 Votes"
DSPatrick answered ·

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.




·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.