Forum Discussion
DAX formula
I want to remove "demand.00" from values section. I tried INT and ROUND function to solve but nothing worked. If I'm changing it to integer then "3M MDS % change" is also changing to integer, ...
Have you tried FORMAT function ?
FORMAT(YourValue, "0.0") & "%"Sorry but it is still showing same as above.
Yes, I tried.
IF(ISBLANK(MAX(Append1[Month-Year]))=FALSE(),IF(DISTINCTCOUNT(Append1[Month-Year])>1,FORMAT(Change, "0.00") & "%",FORMAT(SUM(Append1[Demand]), "")))
and it worked.
Thankyou so much.Great. Please mark my solution as solved.
Have you tried FORMAT function ?
FORMAT(YourValue, "0.0") & "%"Yes, I tried.
IF(ISBLANK(MAX(Append1[Month-Year]))=FALSE(),
IF(DISTINCTCOUNT(Append1[Month-Year])>1,
FORMAT(Change, "0.00") & "%",
FORMAT(SUM(Append1[Demand]), "")
)
)
and it worked.
Thankyou so much.
and it worked.
Thankyou so much.
Great. Please mark my solution as solved.