Forum Discussion
Helper IIIError while adding month
Please help me with below error.
I am getting this while trying to add month value from Data table to the matrix chart - which contains list of salesman in rows and some measured totals in 3 colums
Hi anoomohan,
The Number and Multiple arguments must have the same sign (+/-).
Please check the CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023) part of [2023 SALES B4] for negative numbers.Use MROUND ( number, SIGN ( number ) * multiple ) if the the sign of the number is not known in advance:
2023 SALES B4 = VAR __m = CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023) VAR __result = MROUND(__m,SIGN(__m)*1000) RETURN __resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group
5 Replies
Hi anoomohan,
The Number and Multiple arguments must have the same sign (+/-).
Please check the CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023) part of [2023 SALES B4] for negative numbers.Use MROUND ( number, SIGN ( number ) * multiple ) if the the sign of the number is not known in advance:
2023 SALES B4 = VAR __m = CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023) VAR __result = MROUND(__m,SIGN(__m)*1000) RETURN __resultBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly--How to provide sample data in the Power BI Forum--China Power BI User Group
- Fowmy
Super User
It seems your measure [2023 Sales B4] has an issue when you use the MROUND function. check the parameter value you have sed there. Here is the guide: MROUND function (DAX) - DAX | Microsoft Learn
anoomohanBelow are the 3 measures used in same report - but no error for 2nd and 3rd, not sure why only the first one shows error -2023 SALES B4 = MROUND(CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year]=2023),1000)2024 TGT AFT TR = MROUND(CALCULATE(SUM('AFTER TRANSFER'[Value]), 'DATE'[Year] = 2024),1000)2024 TGT B4 TR = MROUND(CALCULATE(SUM('BEFORE TRANSFER'[Value]), 'DATE'[Year] = 2024),1000)- anoomohan
Thank you, it works this way!
- anoomohan
If if correct the desktop file, do i need to republish in service for this measure to be updated?
