Skip to main content
cancel
Showing results for 
Search instead 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

Reply
Fistachpl
Frequent Visitor

DAX how to calculate the performance of the department

Hello I have a cookie company

 

MonthDepartmentSales

01.01.2023Center15
01.01.2023South22
01.01.2023North32
01.02.2023Center11
01.02.2023South12
01.02.2023North44
01.03.2023Center33
01.03.2023South21
01.03.2023North19

 

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

 

Thank You for Your help!

1 ACCEPTED SOLUTION
ThxAlot
Super User
Super User

ThxAlot_0-1681759853936.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



View solution in original post

2 REPLIES 2
ThxAlot
Super User
Super User

ThxAlot_0-1681759853936.png



Expertise = List.Accumulate(


        {Days as from Today},


        {Skills and Knowledge},


        (Current, Everyday) => Current & Day.LeanAndPractise(Everyday)


)



Hello,

 

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors