12-06-2018 02:59 AM
1. Automated Invoice ID Generator FOr eg :
and so on LOL-BOB201800041...................
2.I want to turn number into words
Five Hundred Fifty Five Dollars and fifty five cents
12-06-2018 10:11 PM
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.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.