Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |