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.
1. Automated Invoice ID Generator FOr eg :
LOL-BOB201800040 |
and so on LOL-BOB201800041...................
2.I want to turn number into words
555.55
Solution
Five Hundred Fifty Five Dollars and fifty five cents
Hi @qwaiti27231,
For the 1st question, we can create calculated table and columns as below.
Table = GENERATESERIES(201800040,201800200,1)
Column = "LOL-BOB"
Invoice ID = CONCATENATE('Table'[Column],'Table'[Value])
Or using the formula to create a calculated column is another close way.
Column = FORMAT(Table1[number],"Currency")
For more details ,please check the pbix as attached.
Regards,
Frank
For that 2nd question can u show me how to do it python ???
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |