Forum Discussion
anoomohan
Helper III
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 col...
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
anoomohanHelper III
Helper IIIThank you, it works this way!