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 We are having problem with this function that we wrote.
Solved! Go to Solution.
Hi @Boe
Pleasr try
Min value, hammadde bazında =
VAR duedate =
TODAY ()
VAR CurrentSymbolTable =
CALCULATETABLE (
'VA05-Açık Sipariş',
ALLEXCEPT ( 'VA05-Açık Sipariş', 'VA05-Açık Sipariş'[Hammadde / Çap] )
)
VAR myFilter =
FILTER (
CurrentSymbolTable,
'VA05-Açık Sipariş'[30 Gün önceki Tarih Bilgisi] <= duedate
&& 'VA05-Açık Sipariş'[mın value] < 0
)
VAR mySummary =
SUMMARIZE (
myFilter,
'VA05-Açık Sipariş'[Malzeme],
"@AverageMinValue", AVERAGE ( 'VA05-Açık Sipariş'[mın value] )
)
RETURN
SUMX ( mySummary, [@AverageMinValue] )
Hi @Boe
Pleasr try
Min value, hammadde bazında =
VAR duedate =
TODAY ()
VAR CurrentSymbolTable =
CALCULATETABLE (
'VA05-Açık Sipariş',
ALLEXCEPT ( 'VA05-Açık Sipariş', 'VA05-Açık Sipariş'[Hammadde / Çap] )
)
VAR myFilter =
FILTER (
CurrentSymbolTable,
'VA05-Açık Sipariş'[30 Gün önceki Tarih Bilgisi] <= duedate
&& 'VA05-Açık Sipariş'[mın value] < 0
)
VAR mySummary =
SUMMARIZE (
myFilter,
'VA05-Açık Sipariş'[Malzeme],
"@AverageMinValue", AVERAGE ( 'VA05-Açık Sipariş'[mın value] )
)
RETURN
SUMX ( mySummary, [@AverageMinValue] )
Thank you.It worked perfectly.Thank you for your time and work.
You can access our Sample Data from here as well;
Malzeme | 30 Gün önceki Tarih Bilgisi | mın value | Min value, hammadde bazında |
4000997 | 20 Mar 2022 | -0,20679 | -18,2091 |
4000997 | 11 Ara 2022 | -0,20679 | -18,2091 |
4001005 | 11 Eki 2022 | 0,002378 | -18,2091 |
4000997 | 20 Mar 2020 | -0,20679 | -18,2091 |
4000970 | 2 May 2022 | -0,0002 | -18,2091 |
4000966 | 26 Ağu 2022 | -0,94448 | -18,2091 |
4000973 | 2 May 2022 | 0,715661 | -18,2091 |
4000973 | 26 Ağu 2022 | 0,715661 | -18,2091 |
4000966 | 2 May 2022 | -0,94448 | -18,2091 |
4000970 | 26 Ağu 2022 | -0,0002 | -18,2091 |
4044492 | 2 Oca 2023 | -18,2091 | |
4063452 | 17 Kas 2022 | -0,46031 | -18,2091 |
4022388 | 7 Haz 2022 | -2,39412 | -18,2091 |
4021106 | 7 Haz 2022 | -1,05643 | -18,2091 |
4021533 | 7 Haz 2022 | -2,73499 | -18,2091 |
4021214 | 7 Haz 2022 | -0,53798 | -18,2091 |
4066874 | 30 Kas 2022 | -0,01521 | -18,2091 |
4064591 | 18 Eki 2022 | -2,82837 | -18,2091 |
4064591 | 29 Oca 2023 | -2,82837 | -18,2091 |
4064591 | 29 Oca 2023 | -2,82837 | -18,2091 |
4064591 | 19 Ara 2022 | -2,82837 | -18,2091 |
4064591 | 18 Eki 2022 | -2,82837 | -18,2091 |
4000127 | 30 Ara 2022 | 48,13617 | -18,2091 |
4000127 | 6 Ara 2022 | 48,13617 | -18,2091 |
4000127 | 11 Kas 2022 | 48,13617 | -18,2091 |
4000127 | 11 Kas 2022 | 48,13617 | -18,2091 |
4000127 | 21 Ara 2022 | 48,13617 | -18,2091 |
4064591 | 23 Eki 2022 | -2,82837 | -18,2091 |
4064591 | 19 Ara 2022 | -2,82837 | -18,2091 |
4064593 | 19 Ara 2022 | 0,20919 | -18,2091 |
4064593 | 29 Oca 2023 | 0,20919 | -18,2091 |
4064593 | 18 Eki 2022 | 0,20919 | -18,2091 |
4000137 | 21 Ara 2022 | 0,21639 | -18,2091 |
4000137 | 11 Kas 2022 | 0,21639 | -18,2091 |
4064593 | 19 Ara 2022 | 0,20919 | -18,2091 |
4064740 | 19 Ara 2022 | -18,2091 | |
4064740 | 19 Ara 2022 | -18,2091 | |
4066874 | 17 Kas 2022 | -0,01521 | -18,2091 |
4000127 | 6 Ara 2022 | 48,13617 | -18,2091 |
4000127 | 30 Kas 2022 | 48,13617 | -18,2091 |
4000127 | 6 Ara 2022 | 48,13617 | -18,2091 |
4000137 | 6 Ara 2022 | 0,21639 | -18,2091 |
4000127 | 17 Kas 2022 | 48,13617 | -18,2091 |
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 |
---|---|
47 | |
26 | |
19 | |
14 | |
10 |
User | Count |
---|---|
58 | |
50 | |
44 | |
19 | |
19 |