Forum Discussion
Formatting first three significant digits extra help
Hi, so I've had this issue before and used the following formula on DAX:
Average Overflow Rate (L/s) = VAR __Value = [event_avg_of_rate]
VAR __Length = LEN(TRUNC(__Value) & "")
VAR __Result =
SWITCH(TRUE(),
__Length >= 3, ROUND(__Value,0),
__Length = 2, ROUND(__Value,1),
__Length = 1, ROUND(__Value,2)
)
RETURN
__ResultWhich helps in a way, however for values like '6.2' or '2' it doesn't convert to '6.20' and '2.00'. Is there a way that I can add or edit the DAX formula to include such things? I'm kind of stuck at figuring out a solution.
Thanks in advance!
Hi Amazing_Random ,
Please try:
Average Overflow Rate (L/s) = VAR __Value = [event_avg_of_rate] VAR __Length = LEN(TRUNC(__Value) & "") VAR __Result = SWITCH(TRUE(), __Length >= 3, FORMAT(__Value,"0"), __Length = 2, FORMAT(__Value,".0"), __Length = 1, FORMAT(__Value,".00") ) 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
1 Reply
Hi Amazing_Random ,
Please try:
Average Overflow Rate (L/s) = VAR __Value = [event_avg_of_rate] VAR __Length = LEN(TRUNC(__Value) & "") VAR __Result = SWITCH(TRUE(), __Length >= 3, FORMAT(__Value,"0"), __Length = 2, FORMAT(__Value,".0"), __Length = 1, FORMAT(__Value,".00") ) 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