Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |