Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
please for explanation how to write dax formula for:
I need get max value from sums of sold products per week.
This final value will be used as max value of y-axis for combo chart.
I have several salled product per week but it is written sale by sale. It should be clear from the tabel.
date | week | sold products | sold products per week | max of week sell |
01.01.2023 | 1 | 5 | 30 | 103 |
01.01.2023 | 1 | 2 | 30 | |
03.01.2023 | 1 | 6 | 30 | |
04.01.2023 | 1 | 1 | 30 | |
05.01.2023 | 1 | 5 | 30 | |
05.01.2023 | 1 | 3 | 30 | |
07.01.2023 | 1 | 8 | 30 | |
08.01.2023 | 2 | 5 | 103 | |
09.01.2023 | 2 | 4 | 103 | |
12.01.2023 | 2 | 2 | 103 | |
12.01.2023 | 2 | 6 | 103 | |
12.01.2023 | 2 | 82 | 103 | |
13.01.2023 | 2 | 1 | 103 | |
14.01.2023 | 2 | 3 | 103 | |
16.01.2023 | 3 | 6 | 84 | |
16.01.2023 | 3 | 8 | 84 | |
17.01.2023 | 3 | 1 | 84 | |
18.01.2023 | 3 | 55 | 84 | |
19.01.2023 | 3 | 3 | 84 | |
20.01.2023 | 3 | 11 | 84 |
Solved! Go to Solution.
For fun only, a showcase of power of Excel formulas, week column isn't necessary.
Of coz, DAX is born for such kind of scenario,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
thank you, it is great.
For fun only, a showcase of power of Excel formulas, week column isn't necessary.
Of coz, DAX is born for such kind of scenario,
Expertise = List.Accumulate( {Days as from Today}, {Skills and Knowledge}, (Current, Everyday) => Current & Day.LeanAndPractise(Everyday) ) |
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |