Hey,
i got a flow where i a table out of my Power BI report and save it as a .csv in a Sharepoint folder.
This is my query text:
DEFINE
VAR _ma1 =
SUMMARIZECOLUMNS(
"Urlaub", SUM(PersonnelManagement_EmployeeDayBalances[Offene Urlaubsstunden]),
"Zeitausgleich", SUM(PersonnelManagement_EmployeeDayBalances[Offener Zeitausgleich])
)
EVALUATE
_ma1
-> I researched the web a lot and imo the query text should be correct.
Results:
Question:
Why doesn't it seperate it in two columns?
In DAX editor it's seperating the results in 2 columns...
Would be happy if someone can help me out 🙂
Hi @lbendlin,
thanks for you help. How do i change the delimiter in the "create csv" action? There aren't any dynamic values here
This is working as designed . (you can simplify it by
EVALUATE SUMMARIZECOLUMNS(
"Urlaub", SUM(PersonnelManagement_EmployeeDayBalances[Offene Urlaubsstunden]),
"Zeitausgleich", SUM(PersonnelManagement_EmployeeDayBalances[Offener Zeitausgleich])
)
Your next step (Csv-Tabelle erstellen) is converting the result of the DAX query into a table. Make sure you specify the right column separator.