cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qwaiti27231 Regular Visitor
Regular Visitor

Need Help In Invoice

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

2 REPLIES 2
Highlighted
Community Support Team
Community Support Team

Re: Need Help In Invoice

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])
For the 2cd question, it could not be done by DAX currently. You can work that by pyhton to work aroud. Please check the bolg to work on that.
 
 

Or using the formula to create a calculated column is another close way.

 

Column = FORMAT(Table1[number],"Currency")

Capture.PNG

 

For more details ,please check the pbix as attached.

 

Regards,

Frank

 

 

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
qwaiti27231 Regular Visitor
Regular Visitor

Re: Need Help In Invoice

For that 2nd question can u show me how to do it python ???

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 131 members 1,742 guests
Please welcome our newest community members: