Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hey all,
I have one dax to calculate either WOS or inventory (see below). Given that, I want to show 1 decimal of my WOS, but integer for my inventory. How should I edit my dax to reflect what I want?
I treid both fixed and round function, but none works for me. Thanks!
Solved! Go to Solution.
Hello @naoyixue1
you can use the format() function to get the desired output
check the demo measure below
@Anonymous Thanks!
Hello @naoyixue1
you can use the format() function to get the desired output
check the demo measure below
User | Count |
---|---|
85 | |
75 | |
73 | |
70 | |
57 |
User | Count |
---|---|
98 | |
97 | |
92 | |
78 | |
70 |