Forum Discussion
Solved
DAX Function - FORMAT( x, "Standard") need "Whole"
I am utilizing a Matrix visual to provide my main stats in a vertical format. Each stat has a value and a % to Total. - Each stat is associated to a device.(Top Row) - Each stat is an inidividual D...
Hi dal2klc ,
Please try below dax formula:
[- Metric#] = MID(FORMAT([Bad Label], "Standard"),1,LEN(FORMAT([Bad Label], "Standard"))-3) & " / " & ROUND(([Bad Label] / [Scan Volume])*100,2) & "%"))Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi dal2klc ,
Please try below dax formula:
[- Metric#] = MID(FORMAT([Bad Label], "Standard"),1,LEN(FORMAT([Bad Label], "Standard"))-3) & " / " & ROUND(([Bad Label] / [Scan Volume])*100,2) & "%")) Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your assistance, I should have thought about LEN, I appreciate your help!
