Export Visual to CSV

[alir22456]

Hi,

I have created a Table viusalization in my Power BI report. The table consists of a list of names of customers. I did export the visualization to csv, but the measure name was also exported along with the values. Is there a way to export only the values and not the column headers / measure names as below:

Name1,Name2,Name3,Name4...........

Thanks

[Anonymous]

Hi @alir22456 ,

Whether the advice given by @MFelix has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[sroy_16]

Hi @alir22456 

Please try using this modofoed DAX and see if it works.

Cohort =
VAR __tmpTable1 =
GENERATE(
DISTINCT('Table'[Customers]),
EXCEPT(
DISTINCT('Table'[Services]),
CALCULATETABLE(DISTINCT('Table'[Services]))
)
)
VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
RETURN
__tmpTable3

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[alir22456]

Hi @sroy_16 

Encountering the following error:

a table of multiple values was supplied where a single value was expected.

[MFelix]

Hi @alir22456 ,

You cannot configure the csv output to not get the names, since it's a csv format the first row is always the name of the columns you have in this case the measures names.

[alir22456]

Hi @MFelix 

Thank you for your comment. Can you please tell me how can I modify the below formula to get a list of customer names each in a separate row rather than seperated by comma.

Cohort = 
VAR __tmpTable1 =
GENERATE(
DISTINCT('Table'[Customers]),
EXCEPT(
DISTINCT('Table'[Services]),
CALCULATETABLE(DISTINCT('Table'[Services]))
)
)
VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
VAR __Result = CONCATENATEX(__tmpTable3, [Customers], ",", [Customers])
RETURN
__Result

Note: I need the names in a new row not a line break

Thanks

[MFelix]

Hi @alir22456 ,

Try the following code:

Cohort = 
VAR __tmpTable1 =
GENERATE(
DISTINCT('Table'[Customers]),
EXCEPT(
DISTINCT('Table'[Services]),
CALCULATETABLE(DISTINCT('Table'[Services]))
)
)
VAR __tmpTable2 = SUMMARIZE(__tmpTable1, 'Table'[Customers])
VAR __tmpTable3 = EXCEPT(DISTINCT('Table'[Customers]), __tmpTable2)
VAR __Result = CONCATENATEX(__tmpTable3, [Customers], UNICHAR(10), [Customers])
RETURN
__Result

Unichar(10) is the line break character.