Forum Discussion

alir22456's avatar
alir22456
Helper I
2 years ago

Export Visual to CSV

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 alon...
Need Help
MFelix's avatar
MFelix
Super User
2 years ago

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's avatar
alir22456
Helper I
2 years ago

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's avatar
    MFelix
    Super User
    2 years ago

    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.