Help needed with 2 measurzs

Anonymous — Thu, 17 Aug 2023 10:48:37 GMT

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!!!

Re: Help needed with 2 measurzs

vicky_ — Fri, 18 Aug 2023 04:48:57 GMT

remember to close your brackets (the end of the 2, SUM('Data input'... doesn't have a closing bracket.)

The second one is also a bracket issue.

Re: Help needed with 2 measurzs

Anonymous — Fri, 18 Aug 2023 09:12:24 GMT

Thank you very much vicky_ ! I have managed to fix the first measure, it's working fine now 🙂

topic Help needed with 2 measurzs in DAX Commands and Tips

Help needed with 2 measurzs

Re: Help needed with 2 measurzs

Re: Help needed with 2 measurzs