Quotas

Anything related to PowerPivot and DAX Formuale
william409
Posts: 2
Joined: Sat Dec 23, 2017 12:37 am

Quotas

Postby william409 » Sat Jan 20, 2018 2:59 am

Lot's of great sales data presentation in "Learn to Write DAX". To make it more useful to me I need to know how you put Quota numbers into the Pivot Tables; quotas for such things as an individual store, an individual salesperson, or a specific inventory item. Hope you can advise me here.

MattAllington
Posts: 999
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Quotas

Postby MattAllington » Mon Jan 22, 2018 7:45 am

Do you mean like a budget? You can simply load another table. I have a few articles
here https://exceleratorbi.com.au/multiple-d ... wer-pivot/
and here https://exceleratorbi.com.au/virtual-fi ... g-treatas/
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training

william409
Posts: 2
Joined: Sat Dec 23, 2017 12:37 am

Re: Quotas

Postby william409 » Tue Jan 23, 2018 5:00 am

Thank you Matt for your quick response. Since you mentioned it, quota and budget would be essentially the same, that of meeting a numerical goal. I will study for articles thoroughly! :D


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 8 guests