Forum Discussion
Helper IIIError while adding month
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
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
__result Best Regards,
Gao
Community Support Team
If 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