Forum Discussion

anoomohan's avatar
anoomohan
Icon for Helper III rankHelper III
2 years ago
Solved

Error 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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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