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
How can I add decimal point where I want to?
I have ex. number 521692155 in table but it should be 5216921,55.
If I use the comma tool in column tools it just adds 2 zeros on top if it like 521692155,00.
I also tried with Column = LEFT(table[data],7) + "," +RIGHT(table[data],2) but then it gives me error that "," cant be a number.
Solved! Go to Solution.
@Anonymous , I think you should divide this number by 100
Ok incremental refresh would work fine but problem is now that I am using a custom SQL. That's why I can't get incremental refresh working for this report. I am going to redo the whole report but for now is there a way I could manually add missing last weeks data without overwriting? The report is almost 1GB big and already has around 6 months of data in it, I only need to add the last weeks data for viewers until I'm finished with the new improved report.
@Anonymous , I think you should divide this number by 100
Of course, forgot about this, seems like I need a break 😄 thank you.
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 |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |