cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

## DAX how to calculate the performance of the department

Hello I have a cookie company

MonthDepartmentSales

 01.01.2023 Center 15 01.01.2023 South 22 01.01.2023 North 32 01.02.2023 Center 11 01.02.2023 South 12 01.02.2023 North 44 01.03.2023 Center 33 01.03.2023 South 21 01.03.2023 North 19

I want to filter it by year and month and:
- calculate sales by all deparments in the selected time period

- calculate the rank of each department by: amount of sold cookies by this department / maximum sold amount of cookies by single department in the selected time period * 5

Example:

In January and February the departments sold:
North: 76
South: 34
Center: 26

Maximum amount sold in this perdiod of time by one is therefore: 76

So calculated ranks of each department should be:
For North: 76/76*5 = 5
For South: 34 / 76 *5 = 2,24
For Center: 26/76*5=1,71

I can't figure out which functions I need to use.

Here is the file if You need it

https://1drv.ms/u/s!AmhVPCf3VN6XiRHGtgwsmUavlgee?e=BaEriZ

1 ACCEPTED SOLUTION
Super User

 Expertise = List.Accumulate(        {Days as from Today},        {Skills and Knowledge},        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday))

2 REPLIES 2
Super User

 Expertise = List.Accumulate(        {Days as from Today},        {Skills and Knowledge},        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday))

Frequent Visitor

Hello,

thank You for Your answer. How can I copy these values to another table?