How to format data and export in the same format

[gaby58]

Hi all,

  Please seebelowand let me know when I export the data whether it is possible to get the values in that format.

Thank you so much for any tips

Required

Date (Format must be: YYYYMMDD)

20230517

Partner ID

0010

Program ID (4 Digits)

1231

Promotion ID (0 if not sure)

1

Payment Memo (64 characters max)

Recipient Name

Street Address

Location

Notification

Taxable

Direct Claim

Online Registration

Partner User ID

Ecount ID

First

Middle

Last

Suffix

Line 1

Line 2

City

State

Postal

Country

Home Phone

Mobile Phone

Email

Code

Amount

Indicator

Flag

Flag

Required

Access Level

Passthrough

(50 characters)

(16 characters)

(25 characters each)

(26 characters each)

(18 characters)

(2 char. abbr.)

(10 digits only)

(2 char. ISO)

(16 characters)

(16 characters)

(50 characters)

(32 char. max)

(10 digits max)

(1, 0 or blank)

(1, 0 or blank)

(1, 0 or blank)

(1, 0 or blank)

(2 digits max.)

(32 char. max.)

123456

First

Last

11122 test lane

Cypress

TX

123456

US

test.one@

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

1

[v-cgao-msft · Accepted solution]

Hi @gaby58 ,

You may consider using Table.TransformColumns() to convert the columns that need to determine whether they are 1 or 0 or null.

Some columns can be formatted on the desktop.

Date:

Parther ID:

FORMAT function (DAX) - DAX | Microsoft Learn

The data can then be quickly exported with the help of external tools.

Export Data | DAX Studio

Here we choose the Formatted File;

then run the query:

EVALUATE YourTableName

Open with Notepad

result:

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum