Hi all,
I am a newbie in the community and in Power Bi world and I am seeking for help.
Could anyone help me to understand what is wrong in these 2 measures?
EUR_month = IF(Day(Today()) >=10,
SWITCH(
YEAR(TODAY()),
2023,
SWITCH(MONTH(TODAY()),
1, SUM('Data input'[31/12/2022 €]),
2, SUM('Data input'[01/31/2023 €],
3, SUM('Data input'[02/28/2023 €]),
4, SUM('Data input'[03/31/2023 €]),
5, SUM('Data input'[04/30/2023 €]),
6, SUM('Data input'[05/31/2023 €]),
7, SUM('Data input'[06/30/2023 €]),
8, SUM('Data input'[07/31/2023 €]),
9, SUM('Data input'[08/31/2023 €]),
10, SUM('Data input'[09/30/2023 €]),
11, SUM('Data input'[10/31/2023 €]),
12, SUM('Data input'[11/30/2023 €]),
13, SUM('Data input'[12/31/2023 €]),
2024,
SUM('Data input'[01/31/2024 €]),
SWITCH(
YEAR(TODAY()),
2023,
SWITCH(MONTH(TODAY()),
1, SUM('Data input'[31/12/2022 €]),
2, SUM('Data input'[01/31/2023 €],
3, SUM('Data input'[02/28/2023 €]),
4, SUM('Data input'[03/31/2023 €]),
5, SUM('Data input'[04/30/2023 €]),
6, SUM('Data input'[05/31/2023 €]),
7, SUM('Data input'[06/30/2023 €]),
8, SUM('Data input'[07/31/2023 €]),
9, SUM('Data input'[08/31/2023 €]),
10, SUM('Data input'[09/30/2023 €]),
11, SUM('Data input'[10/31/2023 €]),
12, SUM('Data input'[11/30/2023 €]),
13, SUM('Data input'[12/31/2023 €]),
2024,
SUM('Data input'[11/30/2023 €]))
ISSUE: Too many arguments were passed to the SUN function. The maximum augement count for the function is 1.
FTE_month =
var _FTE_month = IF(Day(Today()) >=10,
SWITCH(
YEAR(TODAY()),
2023,
SWITCH(MONTH(TODAY()),
1, ROUND(SUM('Data input'[31/12/2022]),2),
2, ROUND(SUM('Data input'[31/01/2023]),2),
3, ROUND(SUM('Data input'[28/02/2023]),2),
4, ROUND(SUM('Data input'[31/03/2023]),2),
5, ROUND(SUM('Data input'[30/04/2023]),2),
6, ROUND(SUM('Data input'[31/05/2023]),2),
7, ROUND(SUM('Data input'[30/06/2023]),2),
8, ROUND(SUM('Data input'[31/07/2023]),2),
9, ROUND(SUM('Data input'[31/08/2023]),2),
10, ROUND(SUM('Data input'[30/09/2023]),2),
11, ROUND(SUM('Data input'[31/10/2023]),2),
12, ROUND(SUM('Data input'[30/11/2023]),2),
13, ROUND(SUM('Data input'[31/12/2023]),2),
2024,
ROUND, (SUM('Data input'[31/01/2024]),2),
SWITCH(
YEAR(TODAY()),
2023,
SWITCH(MONTH(TODAY()),
1, ROUND(SUM('Data input'[31/12/2022]),2),
2, ROUND(SUM('Data input'[31/01/2023]),2),
3, ROUND(SUM('Data input'[28/02/2023]),2),
4, ROUND(SUM('Data input'[31/03/2023]),2),
5, ROUND(SUM('Data input'[30/04/2023]),2),
6, ROUND(SUM('Data input'[31/05/2023]),2),
7, ROUND(SUM('Data input'[30/06/2023]),2),
8, ROUND(SUM('Data input'[31/07/2023]),2),
9, ROUND(SUM('Data input'[31/08/2023]),2),
10, ROUND(SUM('Data input'[30/09/2023]),2),
11, ROUND(SUM('Data input'[31/10/2023]),2),
12, ROUND(SUM('Data input'[30/11/2023]),2),
13, ROUND(SUM('Data input'[31/12/2023]),2),
2024,
ROUND(SUM('Data input'[31/01/2024]),2)
return _FTE_month
ISSUE: The syntax for 'return' is incorrect.
Thank you very much!!!
