Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 ???
User | Count |
---|---|
140 | |
113 | |
104 | |
76 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |