Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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) ) |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
106 | |
88 | |
74 | |
69 |
User | Count |
---|---|
123 | |
112 | |
95 | |
83 | |
73 |