Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Team,
Suppose, I have value - 234384.
And I need formatting like 2,34,384 not 234,384 using DAX as I am using it in dynamic formatting measure.
Thank You.
Solved! Go to Solution.
So you want commas placed at specific points in the value? Will it be the same point everytime? For that number you could write a Concatante() function using Left() Middle() and Right()
I'm guessing that you are OK with having the values in text format?
So you want commas placed at specific points in the value? Will it be the same point everytime? For that number you could write a Concatante() function using Left() Middle() and Right()
No, everytime there will be different values
Do you want to be placing them in a consistent location in the value?
So for that number in your post the formula you could use is:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |